Query time 0.22532
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1508.35"
},
"nested_loop": [
{
"table": {
"table_name": "inventory",
"access_type": "system",
"possible_keys": [
"pc"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "880"
},
"used_columns": [
"product_id",
"amount"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "ALL",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"rows_examined_per_scan": 7821,
"rows_produced_per_join": 132,
"filtered": "1.69",
"cost_info": {
"read_cost": "793.12",
"eval_cost": "13.23",
"prefix_cost": "806.35",
"data_read_per_join": "343K"
},
"used_columns": [
"category_id",
"company_id",
"usergroup_ids",
"status"
],
"attached_condition": "((`maniamall_cscart`.`cscart_categories`.`company_id` = 1) and (`maniamall_cscart`.`cscart_categories`.`category_id` in (290,1035,1044,1088,1090,1205,1207,1114,1279,6794,1131,1318,1201,1264,1266,2382,2699,13057,1306,1310,1325,1345,1375,19445,19446,19491,19568,20830,20923,21141,21171,19497,19540,19541,19542,19548,19577,19827,20792,20827,20834,20924,20925,20927,20930,20961,21089,21091,21115,19566,19756,20793,20794,20835,20968,21157,20928,20929,21583,20975,21323,23230,23276,23252,23255,23256,23855,23258,23262,23840,28622,23263,23264,23265,23277,23847,23282,23399,23306,23307,23323,23332,23393,2616,2642,2643,2686,2696,2689,2700,2702,2706,2790,29881,5111,23462,23463,23464,23465,5112,5113,5114,5115,5116,5117,5118,5119,5120,5121,5122,5123,5124,5125,5126,5127,5128,5129,5130,5131,5132,5133,5134,5366,5135,5136,5137,5138,5139,5140,5141,5142,5143,5144,5145,5146,5147,5148,5149,7213,5365,5371,5375,7212,5377,7206,7207,5384,5385,5386,5417,5432,7230,7231,7232,7233,5388,7181,7182,5390,5406,7210,7211,5747,5748,5749,5750,5751,5752,5753,5754,5755,7183,7184,7185,7186,7187,7188,7189,7193,7194,7197,7198,7190,7191,7192,7195,7196,7199,7200,7201,7202,7203,7204,7205,7208,7209,7214,7215,7216,7217,5187,5716,5772,6628,6795,7122,7162,8780,8781,8908,1098,10851,10855,10857,10874,10886,32186,10887,10892,10893,10894,10895,10913,10914,10930,10933,10934,10940,10955,10956,10960,10964,10967,10976,10981,10983,10988,11013,11014,11085,11102,11112,11116,11122,1152,1165,12994,12995,13435,13446,13450,13461,1412,1452,1465,15302,1571,16568,16582,16836,16864,16887,17028,17042,17053,1720,19350,19351,19543,19564,19565,19580,19581,20749,20750,20751,20752,20753,20754,20755,20756,20757,20768,20758,20759,20760,20761,20762,20789,20763,20764,20765,20766,20767,20769,20770,20780,20781,20771,20772,21183,20773,20774,20782,21068,20775,20776,20777,20778,20779,20783,20784,20785,20786,20787,20788,20790,20791,21184,20979,20980,21033,21037,21112,21127,21128,19386,19387,19571,19601,20741,20742,20810,21164,21169,21238,21366,19474,21177,19506,19507,21587,19544,19545,19546,19547,20944,20945,20950,20946,20947,20948,20949,20951,20952,20953,20800,19555,19556,20815,20817,20819,20823,20825,20828,20829,20831,20926,20931,19731,19732,21139,21180,21333,21388,20976,20977,21041,21111,21116,21162,21163,21334,21179,20993,20994,21390,21065,21066,21159,21324,21325,21326,21327,21328,21329,21330,21331,21332,21335,21336,21337,21168,21172,21173,21175,21178,23102,23191,23192,23193,23194,23432,23197,23345,23878,23347,28716,23246,23281,23310,23311,23360,23816,23854,23884,23295,23296,23298,28607,28714,23301,23308,28636,23312,23861,23440,23512,23513,23729,23739,23740,23767,23784,23786,23787,2726,2876,30008,32185,3126,3129,3154,3172,3174,3177,3184,3251,3252,3256,3274,3275,3341,3358,3398,37427,37428,37430,37434,37436,37438,37440,37441,37442,37443,37444,37445,37446,37447,37449,37451,37452,37453,37455,37456,37457,37458,37459,37460,37461,37462,37463,37464,37465,37466,37467,37468,37469,37470,37471,37472,37473,37474,37475,37476,37477,37478,37482,37483,37484,37485,37486,37487,37488,37489,37490,37491,37492,37494,37495,37497,37500,37501,37502,37503,37505,37506,37509,37510,37511,37514,37515,37519,37520,37521,37522,37523,37524,37526,37527,37528,37529,37530,37531,37532,37533,37534,37535,37536,37537,37538,37539,37540,37541,37542,37543,37544,37545,37546,37547,37549,37550,37551,37553,37554,37555,37557,37558,37559,37560,37561,37562,37563,37564,37565,37566,37568,37571,37572,37573,37574,37575,37576,37577,37579,37580,37581,37582,37584,37585,37586,37587,37588,37589,37591,37592,37593,37604,37605,37606,37607,37608,37609,37610,37611,37612,37613,37614,5074,5789,5795,5837,5842,5853,5862,5865,5869,5870,5884,5971,6038,6381,7126,7127,7128,7131,7221,7345,7888,7890,8083,8094,8124,8132,8900,11580,11581,11582,11583,11586,11587,11590,11594,11596,11599,11600,11603,11605,11611,11615,11653,11870,11872,20854,20912,11873,21271,11876,20855,20913,21268,21346,11877,20838,11879,20858,20859,21276,11880,20860,11881,20861,21269,11882,20862,20864,11885,20863,21277,11889,11890,20865,20866,20867,20868,20874,20914,11893,20856,20857,11894,20869,20870,11895,20871,20915,20939,21267,11897,20872,20873,20875,21090,21265,21266,11900,21351,11901,20839,21263,21264,11904,20877,20878,11905,20879,20880,20881,20882,11906,20846,20876,20907,20908,20909,11907,20970,21270,13453,1409,1721,14480,14486,19447,19448,19500,19537,20822,20824,21365,19449,19450,19453,19538,20818,20821,21161,21165,21166,19454,19455,20816,19535,19536,19560,21338,19539,19549,19550,21167,20814,20833,20978,20997,21174,21181,21367,40150,40162,14541,14566,14644,14864,14936,15690,16578,16591,16837,16838,16840,16856,16863,16867,16868,16878,16882,16886,16890,16892,16893,16894,16895,16897,16898,16900,16901,16902,16904,29953,16853,16883,16871,16972,16973,16970,1722,1879,19342,19343,19344,19345,19346,19829,21119,21187,21393,21396,21398,19609,19610,19722,19723,21204,21462,19886,19887,20035,20036,20048,20049,20743,21230,21414,21417,20093,20094,20141,20142,20168,20169,20172,20176,21428,20184,20185,20195,20206,20217,21432,21434,20291,20292,20320,20321,21442,21444,21448,21498,20335,20336,20348,20351,20352,20353,20354,20386,21203,21458,21460,21586,20408,20409,21407,21408,21585,20484,20485,20505,20506,21470,20521,20522,21207,21471,20557,20558,20612,20613,20614,20615,21477,21479,20726,20727,21235,21236,21237,21344,21485,21493,21495,21497,20987,20992,21052,21055,21190,21191,21403,21450,21196,21197,21231,21419,21420,21422,21426,21233,21234,21480,21483,21436,21437,21573,21574,19347,19348,19516,19939,21007,21384,21591,19473,19484,19503,19504,19505,21200,19602,19603,19973,19831,19832,19833,19861,19870,21188,21392,21499,21501,19922,19923,21189,21192,19991,19992,20055,20056,20086,20087,20100,20101,20105,20132,21424,21427,21505,20188,20189,21435,20230,20231,21199,20261,20262,20270,20338,20339,20345,20346,21391,20380,20381,21454,21455,21456,21459,21500,20422,20423,21461,20525,20526,20542,21208,21209,21319,20664,20665,20676,20692,20701,20707,20723,21222,21484,21490,21492,21494,21012,21134,21135,21186,21217,21218,21476,21205,21206,21320,21575,21213,21214,21475,21430,21431,21463,21464,21509,19661,19662,19663,20155,21429,19735,19736,21478,19849,19850,21229,21394,19884,19885,19918,19919,21401,19940,19941,19952,19981,19982,20052,20053,20054,20077,20078,20097,20098,21195,21425,21504,20139,20140,20186,20187,20196,20249,20250,20251,21440,20294,20295,20312,20322,21441,21443,21445,21449,20374,20375,20469,21453,20640,20641,21481,20681,20688,20691,20706,20722,21487,21491,21071,21120,21121,21198,21212,21474,21451,21452,21465,21466,21472,21473,19835,19836,19837,21395,21397,19909,19910,19930,19934,19938,21316,21317,21402,21404,21406,20128,20129,20744,21421,21423,20159,20160,20213,20214,21433,20232,20233,20420,20421,20699,20700,20703,21221,21225,21496,21058,21059,21232,21457,21210,21211,21318,21215,21216,21399,21400,21409,21410,21411,21412,21413,21418,21438,21439,21446,21447,21467,21468,21469,21486,21506,21507,19862,19863,20704,21122,19868,19869,20083,20163,20674,21239,21523,36369,19915,19916,19917,19933,21405,19996,19997,20315,20349,20350,20655,20656,21482,20689,20690,21488,21489,21193,21194,21201,21202,21219,21220,21415,21416,21589,21590,20113,20394,20395,20433,20547,20548,20956,21043,21074,19352,19353,19354,19355,19364,21026,21150,19361,19362,19363,21103,21132,19409,19410,19413,19414,21130,20999,21000,21006,21021,21080,21136,21152,21133,21151,19379,19380,19401,19416,19417,19422,19557,19558,21004,21005,21101,20990,21060,21061,21343,21385,21085,21086,21147,21321,19356,19357,19360,21153,19358,19359,19825,21092,21137,19365,19366,19367,19368,19369,19406,19415,20991,21123,19372,19373,19374,20954,21140,19402,19439,19440,19517,21100,19370,19371,19377,19378,19388,19396,19399,19400,19420,19421,21010,19375,19376,19397,19405,19428,19436,19444,20988,21063,21156,19384,19385,19433,19394,19395,19398,19403,19404,19418,19419,20808,21124,19437,19438,21155,19389,19390,19391,19392,19393,19582,19583,19841,19854,19876,19588,19589,19596,19597,19901,19908,19605,19606,19619,19620,20022,19629,19630,20046,20074,19635,19636,19637,19645,19646,20095,20122,20125,20130,19654,19655,19657,19658,19666,20171,19681,19682,20258,20268,19689,19690,19696,20301,19700,19701,19705,19729,19730,19733,19734,20609,19739,19740,19743,19744,19750,19751,19824,20666,20680,20729,20736,20738,19970,19971,20437,19988,19989,19995,20192,20193,20243,20244,20365,20366,20377,20464,20507,20508,21035,21070,21079,21082,21083,19523,19524,19525,19745,19755,21357,19586,19587,19613,19614,19615,19622,19623,19640,19641,19644,19651,19783,20096,19673,19674,19694,19695,20317,19703,19704,20179,20180,20252,20253,20263,20431,20432,20497,20498,20584,20585,21126,19426,19427,20037,20040,19432,19932,19948,19985,20013,20071,20116,20158,20209,20290,20347,20502,20683,21023,19434,19456,19457,19458,19459,19752,20668,19461,19462,19650,19652,19653,20111,20114,20117,19616,19617,19987,19633,19634,20402,19638,19639,19669,19670,19671,19672,19675,19676,19679,19680,19698,19699,20279,20283,20328,19770,19771,19900,20011,20012,20177,20178,20368,20369,20500,20501,21381,20537,20538,20539,21572,20569,20570,20607,20608,19460,19463,19464,19465,19466,19467,19738,20601,19584,19585,19853,19878,19591,19592,19624,19625,19631,19642,19643,19790,20121,19659,19660,19664,19665,19667,19668,20197,20203,19685,19686,19712,19713,19715,19716,19724,19725,19726,19727,19728,20515,19741,19742,19747,19753,19754,20667,20702,20714,19777,19778,20032,19799,19800,19801,19802,20284,20293,20311,20238,20239,20323,20531,20532,20545,20546,20565,20566,21076,21077,21084,21095,21097,19468,19469,19470,19471,19472,19867,19913,19914,19928,19962,19963,20406,20006,20007,20020,20023,20974,20025,20026,20033,20034,20039,20062,20063,20066,20073,20076,20089,20103,20104,20115,20153,20154,20190,20191,20208,20275,20276,20332,20414,20415,20443,20444,21223,21224,21352,20451,20452,20453,20462,20468,20470,20471,20488,20489,20495,20496,20519,20971,20575,20576,20588,20657,20658,20670,20671,20679,20708,20725,20732,20972,20973,21350,19478,19479,19480,19494,19495,20119,20123,19520,19521,20693,20696,20716,20730,19838,19839,19847,19855,19866,19856,19857,19892,19893,19905,19906,19920,19921,19926,19946,19947,19951,19954,19968,19979,19980,19993,19994,20008,20009,20081,20082,20143,20144,20174,20175,20199,20200,20235,20236,20254,20255,20287,20288,20310,20304,20305,20318,20324,20325,20360,20361,20376,20396,20438,20439,20445,20446,20455,20467,20473,20459,20460,20486,20487,20494,20503,20504,20518,20591,20592,20644,20645,20650,20651,20711,20712,21348,21349,21355,21356,19481,19482,19483,19840,19848,19864,19875,19492,19493,20102,20138,19526,19527,20673,20705,20713,20731,19890,19891,19902,19903,19907,19927,19929,19931,19935,19937,19949,19950,19961,20401,19974,19975,20000,20001,20002,20003,20019,20030,20031,20060,20061,20064,20079,20080,20090,20091,20147,20148,20166,20167,20173,20211,20212,20221,20222,20225,20226,20245,20264,20265,20267,20277,20278,20282,20296,20297,20298,20299,20300,20306,20314,20319,20330,20331,20340,20341,20342,20355,20356,20373,20390,20412,20413,20424,20425,20461,20492,20493,20511,20512,20520,21382,20527,20528,20535,20549,20550,20567,20568,20582,20583,20587,20596,20642,20643,20652,20981,20982,21125,19485,19486,19487,19528,19529,19896,19897,19966,19967,19969,20058,20059,20070,20152,20201,20202,20604,20605,20653,20654,21042,19498,19499,19976,20273,20307,20364,20454,21342,21353,19501,19502,19590,19595,19649,19656,19714,19720,19721,19737,19749,20038,20075,20092,20285,20337,20440,20534,20559,19510,19511,19512,19513,20465,20466,20474,20477,21011,21014,21032,21034,21039,21051,21053,21062,21067,21073,21113,21114,19607,19608,19687,19688,20266,20269,20272,21531,19845,19846,19860,19882,20720,21510,21511,19898,19899,19911,19912,21512,21513,21514,19944,19945,19953,19957,19958,19959,20430,21515,21516,21552,21559,19983,19984,19986,19990,21517,21518,20004,20005,20010,20014,20018,20472,20028,20029,21347,20041,20042,20047,20403,21519,21520,21521,21522,21524,20084,20085,20108,20109,20110,20112,20120,20126,20127,20131,20135,21525,21526,21527,20145,20146,20164,20165,20170,21528,21529,20181,20182,20183,20194,20198,20207,20210,20215,20216,20220,20227,20228,20229,20234,20237,20240,21530,20247,20248,20303,20308,20313,20316,21532,21533,21534,21535,21594,20326,20327,20358,20359,20367,20370,20379,20382,20385,20393,20398,20399,20479,21539,21540,21541,21542,21543,21544,21545,21546,20404,20405,21547,21548,21549,21550,21551,21553,20441,20442,20447,20448,20490,20491,20523,20524,20529,20536,20541,21354,21570,20563,20564,20580,20581,20586,20594,20595,20610,21558,21560,20659,20660,20661,21561,20662,20663,20669,20675,20678,20682,20715,20721,20724,21562,21563,21564,21565,21566,21567,21568,21569,20697,20698,21554,21555,21556,21557,21536,21537,21538,19522,20677,19530,19531,19532,19746,19819,20709,20719,20728,20737,20739,20740,19598,19599,19600,19767,19627,19628,19632,20088,19647,19648,19787,20099,20124,19677,19678,19683,19684,20257,20259,19691,19692,19693,19697,20286,19717,19718,19719,19806,20392,19757,19758,19828,19834,19842,19865,19877,19883,19761,19762,19894,19816,19817,19818,20533,19942,19943,20428,19998,19999,20223,20224,20343,20344,20418,20419,20436,20513,20514,20517,20551,20552,20560,20561,20573,20599,20600,19533,19559,19593,19594,19604,19626,19702,19748,20400,20530,20958,20959,20960,19611,19612,19618,19972,19621,19759,19760,19766,19823,20540,19763,19764,19765,19769,19904,19794,19795,19798,19873,19874,19977,19978,20067,20068,20106,20107,20118,20133,20156,20157,20416,20417,20427,20509,20510,20578,20579,20602,20684,20685,20694,20717,20735,19768,19772,19773,19774,19788,19789,20134,19796,19797,20274,20302,19843,19844,19859,19881,19888,19889,19895,19924,19925,19936,19955,19956,19960,20429,20024,20050,20051,20057,20069,20260,20371,20372,20378,20410,20411,20426,20966,20463,21104,20480,20481,20482,20483,20589,20590,20593,20646,20647,20649,20733,20734,20967,20964,20965,19775,19776,19784,19793,19803,19858,20357,20516,20562,20648,20710,21064,19779,19780,19781,19782,19785,19786,19791,19792,19804,19805,19807,19808,19809,19810,19811,19812,19813,19814,19815,19820,19821,19822,21024,21025,21028,21044,19871,19872,20072,20397,20458,20686,19879,19880,20017,20271,20362,20363,20407,20449,20450,20577,20695,20745,21008,21016,21029,21030,21031,21096,21129,21144,21145,21148,21149,21508,21596,21597,21588,19407,19408,20832,20986,20995,20996,21020,21045,21048,21081,19411,19412,19431,19570,19573,20027,20043,20811,20812,20989,20998,21001,21002,21003,21018,21027,21046,21047,21054,21056,21057,21087,21088,21105,21106,21131,21362,19423,19424,19425,19569,20813,20962,20963,20983,21017,21040,21078,21107,21108,21154,21389,21571,21584,19429,19430,20957,21019,21050,21185,21387,19508,19509,19826,20955,20985,21013,21038,21049,21069,21072,21386,19561,19562,21110,19574,19575,19576,20149,20150,20151,20204,20205,20543,20544,20555,20556,21098,21099,20387,20388,20389,20553,20554,21358,21359,21360,21502,21503,21592,21593,20969,20984,21015,21022,21036,21075,21102,21345,21361,21009,21143,19381,19382,19383,19496,19572,20809,21138,19435,19451,19452,19534,19567,21160,21170,21117,21118,21182,21339,21363,21226,21227,21228,21580,21582,21576,21577,21578,21579,21581,21682,22522,23187,23455,23456,23457,23508,23511,23498,23499,23500,23501,23502,23503,23504,23505,23663,23664,23728,23766,23775,23891,23892,23896,23898,23899,25367,25368,23900,23903,23904,23905,23906,23907,23908,23909,23910,23911,23912,23913,23914,23915,23916,23917,23918,23919,23920,23921,23922,23923,23924,23925,23926,23927,23928,25369,25370,25371,25372,25373,25374,25375,25376,25377,25378,25379,25380,25381,25382,25383,25384,25385,23929,23930,23931,23932,23933,23934,23935,23936,23937,23938,23939,23940,23941,23942,23943,23944,23945,23946,23947,23948,23949,23950,23951,23952,25386,25387,23953,23954,23955,23956,25388,25389,25390,25391,25392,25393,25394,25395,25396,25397,25398,25399,25400,25401,25402,25403,25404,25405,25406,25407,25408,25409,25410,25411,25412,25413,25414,25415,25416,25417,25418,25419,25420,25421,25422,25423,25424,25425,25426,25427,25428,25429,25430,25431,25432,25433,25434,25435,25436,25437,25438,25439,25440,25441,25442,25443,25444,25445,25446,25447,25448,25449,25450,25451,25452,25453,23957,23958,23959,23960,23961,23962,23963,23964,23965,23966,23967,23968,23969,23970,23971,23972,23973,23974,23975,23976,23977,23978,23979,23980,23981,23982,23983,23984,23985,23986,23987,23988,23989,23990,25474,25475,25476,25477,25478,25479,25480,25481,25482,25483,25484,25485,25486,25487,25488,25489,25490,25491,25492,25493,25494,25495,25496,25497,25498,25499,25500,25501,25502,25503,25504,25505,25506,25507,25508,25509,25510,25511,25512,25513,25514,25515,25516,25517,25518,25519,25520,25521,23991,23992,23993,23994,23995,23996,23997,23998,23999,24000,24001,24002,24003,24004,24013,24014,24015,24016,24017,24018,24019,24020,24021,24022,24023,24024,24025,24026,24027,24028,24029,24030,24031,24032,24033,24034,24035,24036,24037,24038,24039,24040,24041,24042,24043,24044,24045,24046,24047,24048,24049,24050,24051,24052,24053,24054,24055,24056,24057,24058,24059,24060,24061,24062,24063,24064,24065,24066,24067,24068,25522,25523,25524,25525,24069,24070,24071,24072,24073,24074,24075,24076,24077,24078,24079,24080,24081,24082,24083,24084,24085,24086,24087,24088,24089,24090,24091,24092,24093,24094,24095,24096,24097,24098,24099,24100,24101,24102,24103,24104,24105,24106,24107,24108,24109,24110,24111,24112,24113,24114,24115,24117,24118,24119,24120,24121,24122,24123,24124,24125,24126,24127,24128,24129,24130,24131,24132,24133,24134,24135,24136,24137,24138,24139,24140,24141,24142,24143,24144,24146,24147,24148,24149,24150,24151,24152,24153,24154,24155,24156,24157,24158,24159,24160,24161,24162,24163,24164,24165,24166,24167,24168,24169,24170,24171,24172,24173,24174,24175,24176,24177,24178,24179,24180,24181,24182,24183,24184,24185,24186,24187,24188,24189,24190,24191,24192,24193,24194,24195,24196,24197,25526,25527,25528,24198,24199,24200,24201,24202,24203,24204,24205,24206,24207,24208,24209,24210,24211,24212,24213,24214,24215,24216,24217,24218,24219,24220,24223,24224,24225,24226,24227,24228,24229,24230,24231,24232,24233,24234,24235,24236,24237,25536,25537,25538,25539,24238,24239,24240,24241,24242,24243,24244,24245,24246,24247,24248,24249,24250,24251,24252,24253,24254,24255,24256,24257,24258,24259,24260,24261,24262,24263,24264,24265,24266,24267,24268,24269,24270,24271,24272,24273,24274,24275,24276,24277,24278,24279,24280,24281,24282,24283,24284,24285,24286,24287,24288,24289,24290,24291,25540,24292,24293,24294,24295,24296,24297,24298,24299,24300,24301,24302,24303,24304,24305,24306,24307,25541,25542,25543,25544,25545,25546,25547,25548,25549,25550,25551,25552,25553,25554,25555,25556,25557,25558,25559,25560,25561,25562,25563,24310,24311,24312,24313,24314,24315,24316,24317,24318,24319,24320,24321,24322,24323,24324,24325,24326,24327,24328,24329,24330,24331,24332,24333,24334,24335,24336,24337,24338,24339,24340,24341,24342,24343,24344,24345,24346,24347,24348,24349,24350,24351,24352,24353,24354,24355,24357,24358,24359,24360,24361,24362,24363,24364,24365,24366,24367,24368,24369,24370,24371,25564,25565,25566,25567,24372,24373,24374,24375,24376,24377,24378,24379,24380,24381,24382,24383,24384,24385,24386,24387,24388,24389,24390,24391,24392,24393,24394,24395,24396,24397,24398,24399,24400,24401,24402,24403,24404,24405,24406,24407,24408,24409,24410,24411,24412,24413,24414,24415,24416,24417,24418,24419,24420,24421,24422,24423,24424,24425,24426,24427,24428,24429,24430,24431,24432,24433,24434,24435,24436,25793,25794,25795,25796,24437,24438,24439,24440,24441,24442,24443,24444,24445,24446,24447,24448,24449,24450,24451,24452,24453,24454,24455,24456,24457,24458,24459,24460,24461,24462,24463,24464,24465,24466,24467,24468,24469,24470,24471,24472,24473,24474,24475,24476,24477,24478,24479,24480,24481,24482,24483,24484,24485,24486,24487,24488,24489,24490,24491,24492,24493,24494,24495,24496,24497,24498,24499,24500,24501,24502,24503,24504,24505,24506,24507,24508,24509,24510,24511,24512,24513,24514,24515,24516,24517,24518,24519,24520,24521,24522,24523,24524,24525,24526,24527,24528,24529,24530,24531,24532,24533,24534,24535,24536,24537,24538,24539,24540,24541,24542,24543,24544,24545,24546,24547,24548,24835,24836,25849,25850,25851,25852,25853,25854,25855,25856,25857,25858,24549,24550,24551,24552,24553,24554,24555,24556,24557,24558,24559,24560,24561,24562,24563,24564,24565,24566,24567,24568,24569,24570,24571,24572,24573,24574,24575,24576,24577,24578,24579,24580,24581,24582,24583,25859,25860,25861,25862,25863,25864,25865,25866,25867,25868,25869,25870,25871,25872,25873,25874,25875,25876,25877,25878,25879,25880,25881,25882,25883,25884,25885,25886,25887,25888,25889,25890,25891,25892,25893,25894,25895,25896,25897,25898,25899,25900,25901,25902,25903,25904,25905,25906,25907,25908,25909,25910,25911,25912,25913,25914,25915,25916,25917,25918,25919,25920,25921,25922,25923,25924,25925,25926,25927,25928,25929,25930,25931,25932,25933,25934,25935,25936,25937,25938,25939,25940,25941,25942,25943,25944,25945,25946,25947,25948,25949,25950,25951,25952,25953,25954,24584,24585,24586,24587,25955,25956,25957,25958,25959,25960,25961,25962,25963,25964,25965,25966,25967,25968,25969,25970,25971,25972,25973,25974,25975,25976,25977,25978,25979,25980,25981,25982,25983,25984,25985,25986,25987,25988,25989,25990,25991,25992,25993,25994,25995,25996,25997,25998,25999,26000,26001,26002,26003,26004,26005,26006,26007,26008,26009,26010,26011,26012,26013,26014,26015,26016,26017,26018,24588,24589,24590,24591,24592,24593,24594,24595,24596,24597,24598,24599,24600,24601,24602,26019,26020,26021,26022,26023,26024,26025,26026,26027,26028,26029,26030,26031,26032,26033,26034,26035,26036,26037,26038,26039,26040,26041,26042,26043,26044,26045,26046,26047,26048,26049,26050,26051,26052,26053,26054,26055,26056,26057,26058,26059,26060,26061,26062,26063,26064,26065,26066,26067,26068,26069,26070,26071,26072,26073,26074,26075,26076,26077,26078,26079,26080,26081,26082,26083,26084,26085,26086,26087,26088,26089,26090,26091,26092,24603,24604,24605,24606,24607,24608,24609,24610,24611,24612,24613,24614,24615,24616,24617,26093,26094,24618,24621,26095,26096,26097,24622,24623,24624,24625,24626,24627,24628,24630,24631,24632,24633,24634,24635,24636,24637,26167,26168,26169,26170,24638,24639,24640,24641,24642,24643,24644,24645,24646,24647,24648,24649,24650,24651,24652,24653,24654,24655,24656,24657,24658,24659,24660,24661,24662,24663,24664,24665,24666,24667,24668,24669,24670,24671,24672,24673,24674,24675,24676,24677,24678,24679,24680,24681,24682,24683,26171,26172,26173,24684,24685,24686,24687,24688,24689,24690,24691,24692,24693,24694,24695,24696,24697,24698,24699,24700,24701,24702,24703,24704,24705,24706,24707,24708,24709,24710,24711,24712,24713,26174,26175,26176,26177,26178,26179,26180,26181,26182,24714,24715,24716,24717,24718,24719,24720,24721,24722,24723,24724,24725,24726,24727,24728,24729,24730,24731,24732,24733,24734,24735,24736,24737,24738,24739,24740,24741,24742,24743,24744,24745,24746,24747,24748,24749,24750,24751,24752,24753,24754,24755,24756,24757,24758,24759,24760,24761,24762,24763,24764,24765,24766,24767,24768,24769,24770,24771,24772,24773,24774,24775,24776,24777,24778,24779,24780,24781,24782,24783,24784,24785,24786,24787,24788,24789,24790,24791,24792,24794,24795,24796,24797,24798,24799,24800,24801,24802,24803,24804,24805,24806,24807,24808,24809,24810,26183,26184,26185,24811,24812,24813,24814,24815,24816,24817,24818,24819,24820,24821,24822,24823,24824,24825,24826,24827,24828,24829,24830,24831,26340,26341,26342,26343,26344,26345,26346,26347,26348,26349,26350,26351,26352,26353,26354,26355,26356,26357,26358,26359,26360,26361,26362,26363,26364,26365,24837,24838,24839,24840,24841,24842,24843,24844,24845,24846,24847,24848,24849,24850,24851,24852,24853,24854,24855,24856,24857,24858,24859,24860,24861,24862,24863,24864,24865,24866,24867,24868,24869,24870,24871,24872,24873,24874,24875,24876,24877,24878,24879,24880,24881,24882,24883,24884,24885,24886,24887,24888,24889,24890,24891,24892,24893,24894,24895,24896,24897,24898,24899,24900,24901,24902,24903,24904,24905,24906,24907,24908,24909,24910,24911,24912,24913,24914,24915,24916,24917,24918,24919,24920,24921,24922,24923,24924,24925,24926,24927,24928,24929,24930,24931,24932,24933,24934,24935,24936,24937,24938,24939,24940,24941,24942,24943,24944,24945,24946,24947,24948,24949,24950,24951,24952,24953,24954,24955,24956,24957,24958,24959,24960,24961,24962,24963,24964,24965,24966,24967,24968,24969,24970,24971,24972,24973,24974,24975,24976,24977,24978,24979,24980,24981,24982,24983,24984,24985,24986,24987,24988,24989,24990,24991,24992,24993,24994,24995,24996,24997,24998,24999,25000,25001,25002,25003,25004,25005,25006,25007,25008,25009,25010,25011,25012,25013,25014,25015,25016,25017,25018,25019,25020,25021,25022,25023,25024,25025,25026,25027,25028,25029,25030,25031,25032,25033,25034,25035,25036,25037,25038,25039,25040,25041,25042,25043,25044,25045,25046,25047,25048,25049,25050,25051,25052,25053,25054,25055,25056,25057,25058,25059,25060,25061,25062,25063,25064,25065,25066,25067,25068,25069,25070,25071,25072,25073,25074,25075,25076,25077,25078,25081,25084,25087,25090,25091,25092,25093,25094,25095,25096,25097,25098,25099,25100,25101,25102,25103,25104,25105,25106,25107,25108,25109,25110,25111,25112,25113,25114,25115,25116,25117,25118,25119,25120,25121,25122,25123,25124,25125,25126,25127,25128,25129,25130,25131,25132,25133,25134,25135,25136,25137,25138,25139,25140,25141,25142,25143,25144,25145,25146,25147,25148,25149,25150,25151,25152,25153,25154,25155,25156,25157,25158,25159,25160,25161,25162,25163,25164,25165,25166,25167,25168,25169,25170,25171,25172,25173,25174,25175,25176,25177,25178,25179,25180,25181,25182,25183,25184,25185,25186,25187,25188,25189,25190,25191,25192,25193,25194,25195,25196,25197,25198,25199,25200,25201,25202,25203,25204,25205,25206,25207,25208,25209,25210,25211,25212,25213,25214,25215,25216,25217,25218,25219,25220,25221,25222,25223,25224,25225,25226,25227,25228,25229,25230,25231,25232,25233,25234,25235,25236,25237,25238,25239,25240,25241,25242,25243,25244,25245,25246,25247,25248,25249,25250,25251,25252,25253,25254,25255,25256,25257,25258,25259,25260,25261,25262,25263,25264,25265,25266,25267,25268,25269,25270,25271,25272,25273,25274,25275,25276,25277,25278,25279,25280,25281,25282,25283,25284,25285,25286,25287,25288,25289,25290,25291,25292,25293,25294,25295,25296,25297,25298,25299,25300,25301,25302,25303,25304,25305,25306,25307,25308,25309,25310,25311,25312,25313,25314,25315,25316,25317,25318,25319,25320,25321,25322,25323,25324,25325,25326,25327,25328,25329,25330,25331,25332,25333,25334,25335,25336,25337,25338,25339,25340,25341,25342,25343,25344,25345,25346,25347,25348,25349,25350,25351,25352,25353,25354,25355,25356,25357,25358,25359,25360,25361,25362,25363,25364,25365,25366,25454,25455,25456,25457,25458,25459,25460,25461,25462,25463,25464,25465,25466,25467,25468,25469,25470,25471,25472,25473,25529,25530,25531,25532,25533,25534,25535,25568,25569,25570,25571,25572,25573,25574,25575,25576,25577,25578,25579,25580,25581,25582,25583,25584,25585,25586,25587,25588,25589,25590,25591,25592,25593,25594,25595,25596,25597,25598,25599,25600,25601,25602,25603,25604,25605,25606,25607,25608,25609,25610,25611,25612,25613,25614,25615,25616,25617,25618,25619,25620,25621,25622,25623,25624,25625,25626,25627,25628,25629,25630,25631,25632,25633,25634,25635,25636,25637,25638,25639,25640,25641,25642,25643,25644,25645,25646,25647,25648,25649,25650,25651,25652,25653,25654,25655,25656,25657,25658,25659,25660,25661,25662,25663,25664,25665,25666,25667,25668,25669,25670,25671,25672,25673,25674,25675,25676,25677,25678,25679,25680,25681,25682,25683,25684,25685,25686,25687,25688,25689,25690,25691,25692,25693,25694,25695,25696,25697,25698,25699,25700,25701,25702,25703,25704,25705,25706,25707,25708,25709,25710,25711,25712,25713,25714,25715,25716,25717,25718,25719,25720,25721,25722,25723,25724,25725,25726,25727,25728,25729,25730,25731,25732,25733,25734,25735,25736,25737,25738,25739,25740,25741,25742,25743,25744,25745,25746,25747,25748,25749,25750,25751,25752,25753,25754,25755,25756,25757,25758,25759,25760,25761,25762,25763,25764,25765,25766,25767,25768,25769,25770,25771,25772,25773,25774,25775,25776,25777,25778,25779,25780,25781,25782,25783,25784,25785,25786,25787,25788,25789,25790,25791,25792,25797,25798,25799,25800,25801,25802,25803,25804,25805,25806,25807,25808,25809,25810,25811,25812,25813,25814,25815,25816,25817,25818,25819,25820,25821,25822,25823,25824,25825,25826,25827,25828,25829,25830,25831,25832,25833,25834,25835,25836,25837,25838,25839,25840,25841,25842,25843,25844,25845,25846,25847,25848,26098,26099,26100,26101,26102,26103,26104,26105,26106,26107,26108,26109,26110,26111,26112,26113,26114,26115,26116,26117,26118,26119,26120,26121,26122,26123,26124,26125,26126,26127,26128,26129,26130,26131,26132,26133,26134,26135,26136,26137,26138,26139,26140,26141,26142,26143,26144,26145,26146,26147,26148,26149,26150,26151,26152,26153,26154,26155,26156,26157,26158,26159,26160,26161,26162,26163,26164,26165,26166,26186,26187,26188,26189,26190,26191,26192,26193,26194,26195,26196,26197,26198,26199,26200,26201,26202,26203,26204,26205,26206,26207,26208,26209,26210,26211,26212,26213,26214,26215,26216,26217,26218,26219,26220,26221,26222,26223,26224,26225,26226,26227,26228,26229,26230,26231,26232,26233,26234,26235,26236,26237,26238,26239,26240,26241,26242,26243,26244,26245,26246,26247,26248,26249,26250,26251,26252,26253,26254,26255,26256,26257,26258,26259,26260,26261,26262,26263,26264,26265,26266,26267,26268,26269,26270,26271,26272,26273,26274,26275,26276,26277,26278,26279,26280,26281,26282,26283,26284,26285,26286,26287,26288,26289,26290,26291,26292,26293,26294,26295,26296,26297,26298,26299,26300,26301,26302,26303,26304,26305,26306,26307,26308,26309,26310,26311,26312,26313,26314,26315,26316,26317,26318,26319,26320,26321,26322,26323,26324,26325,26326,26327,26328,26329,26330,26331,26332,26333,26334,27987,27988,27989,27990,27991,27992,27993,27994,27995,27996,27997,27998,27999,28000,28001,28002,28003,28004,28005,28006,28007,28008,28009,28010,28011,28012,28013,28014,28015,28016,28017,28018,28019,28025,28026,28027,28028,28029,28030,2799,28395,29877,29879,29880,30134,30404,30405,30407,30463,30464,30489,30468,30469,30473,30474,30477,30486,30490,30491,30496,30498,30501,30503,30510,30471,30472,30476,30499,30509,30511,30475,30478,30479,30480,30481,30482,30492,30512,30552,30553,30554,30555,30557,30558,30561,30562,30514,30515,30516,30517,3118,23526,23527,23528,23529,23530,23531,23532,23533,23534,23535,23536,23537,23538,23539,23540,23541,23542,23543,23544,23545,23546,23547,23548,23549,23550,23551,23552,23553,23554,23555,23556,23557,23558,23559,23560,23561,23562,23563,23564,23565,23566,23567,23568,23569,23570,23571,23572,23573,23574,23575,23576,23577,23578,23579,23580,23581,23582,23583,23584,23585,23586,23587,23588,23589,23590,23591,23592,23593,23594,23595,23596,23597,23598,23599,23600,23601,23602,23603,23604,23605,23606,3119,23497,23514,23515,23516,23517,23518,23519,23520,23521,23736,23742,23782,23783,3120,3159,3182,3206,3207,3208,3218,3247,3253,3276,3279,3281,3286,3287,3362,3385,7903,8081,9709,9710,9725,9726,9741,3124,3125,3185,3186,3187,3188,3189,3190,3191,3192,3193,3194,3198,35523,7902,8133,3155,23734,3156,3160,3161,3162,3173,3175,3176,3195,3196,3197,3211,3213,3214,3221,3250,3255,3280,3288,3289,3290,3302,3304,3316,3340,3342,3383,3388,3405,3413,7889,7905,7906,7907,8082,8095,8122,3356,7892,7893,7899,8126,8140,7894,7895,8084,8089,9760,8098,8099,8102,9711,23608,23609,9712,23737,23770,23771,9713,9724,9742,9745,9747,9749,9753,9714,9715,9716,9717,9718,9719,9720,9722,9723,9729,23730,23731,23732,23772,23773,9730,9731,9732,9733,9734,9735,9736,9737,9738,9739,9740,9748,9743,9744,9746,9750,9751,9752,9754,9755,3121,3391,3127,19349,19563,20820,20826,21094,21146,21341,21383,23735,3128,3141,3163,3164,3336,3353,3355,8093,3165,3166,3167,3354,3309,3343,3344,3345,3346,3347,3348,3130,3131,3132,3133,7886,7887,8090,8091,3219,3308,3139,16839,16907,16912,16916,16847,16861,28022,28023,28024,16908,16909,16910,16911,28021,3140,3303,3305,3306,3339,3389,3142,14829,19442,3143,20842,20843,20844,20845,20847,21259,21373,20849,20850,20921,21245,21379,20851,20852,20885,20886,21254,21255,21256,21374,21376,21378,20889,20890,20894,21249,20902,21250,21260,20916,20917,20918,20919,20920,23103,23104,23105,23624,23657,28052,29863,29864,29865,29866,29867,29868,29869,29870,29871,29872,29875,29876,29878,29882,3144,3145,23509,23610,23612,23613,23614,23618,23620,23621,23622,23623,23779,23791,3146,3147,3148,3149,3150,3151,3152,3153,23650,23651,23765,3199,3200,3201,3202,3203,23646,23648,23661,23764,3238,3239,3240,3241,3242,3243,3244,3245,3246,3261,3271,3272,3273,3317,3359,3360,3382,3222,23678,23701,23702,23703,23704,23713,3223,3224,23665,23666,23667,23668,23669,23670,23671,23672,23778,3225,23673,23674,23675,23676,23677,23790,3226,3227,3228,23683,23684,23685,23686,23687,23688,23689,23690,23691,23692,3229,3230,3231,3232,23693,23694,23695,23696,23697,23698,23699,23700,3233,23631,23705,23706,23707,23708,23709,23710,23711,23712,23789,3234,3235,3236,23721,23722,23723,23724,23725,23726,23727,3237,3262,23679,23680,23681,23682,3263,3264,3265,3266,3267,3269,3270,23714,23715,23716,23717,23718,23719,23720,9761,3248,3257,3258,3374,3377,3282,14827,14828,28053,28054,3283,3310,3311,3312,3313,3314,3315,3318,3337,3361,3365,3366,3369,3370,3371,3372,8113,9708,7901,3157,3158,7891,7900,7904,8754,8755,8756,8757,8764,8765,8758,8759,8760,8761,8762,3168,3169,23494,23495,23496,23506,23507,23510,23524,23525,23733,23738,23768,23769,23776,23777,23785,23792,3170,3215,3220,3321,7897,7898,7908,8085,8086,8087,8092,8134,8709,9721,9728,3178,3179,3180,3209,3301,3204,3205,3210,3217,9727,32577,3259,23607,3260,3294,3295,3296,3297,3298,3299,3300,3320,3351,3392,3393,3394,3395,3396,3397,3407,3408,3409,7909,8128,8129,8130,8131,9763,3380,37429,37431,37432,37433,37435,37437,37439,37448,37450,37454,37479,37480,37481,37493,37496,37498,37499,37504,37507,37508,37512,37513,37516,37517,37518,37525,37552,37556,37567,37569,37570,37578,37590,37594,37595,43883,5157,5257,5286,5287,6342,6634,6706,12086,12087,12088,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6721,6722,6723,6724,6725,6726,6727,6728,6729,6730,6731,6732,6733,6734,6735,6736,6737,6738,6739,6740,6741,6742,6743,7286,7287,7288,7289,7290,7291,8783,8784,7348,7349,7350,7351,7391,7462,7545,7896,7911,23743,23744,23745,23746,23747,7917,23748,23749,23750,7918,7920,7923,7924,7925,7926,7927,7928,7929,7930,7931,7932,7933,7934,7935,7936,7937,7938,7939,7940,7941,7942,7943,7944,7945,7946,7947,7948,7949,7950,7951,7952,7953,7954,7955,7956,7957,7958,7959,7960,7961,7962,7963,7964,7965,7966,7967,7968,7969,7970,7971,23751,23752,23753,23754,23755,7972,7973,7974,7975,7981,7982,7983,7984,7985,23756,23757,23758,7986,7987,7988,7989,7993,7994,7995,7996,7997,23759,23760,23761,23762,23763,8003,8004,8005,8006,8007,8008,8009,8010,8011,8012,8013,8014,8015,8016,8017,8018,8019,8020,8021,8022,8023,8024,8025,8026,8027,8028,8029,8030,8031,8032,8033,8034,8035,8036,8037,8038,8039,8040,8041,8042,8043,8044,8045,8046,8047,8048,8049,8050,8051,8052,8053,8054,8055,8056,8057,8058,8059,8060,8061,8063,8064,8065,8066,8067,8068,8069,8070,8071,8072,8073,8074,8075,8076,8077,8078,8079,8080,8100,23780,8103,8104,8105,8106,8107,8108,8109,8110,8111,8112,8114,8115,8116,8117,8118,8119,8120,8121,8123,8135,8148,8154,8155,8736,8738,8739,8740,8747,8752,9762,9764,8149,8150,8151,8749,8156,8157,8158,8159,8160,8161,8162,8163,8164,8165,8166,8668,8670,8731,8732,8733,8734,8735,8741,8750,8751,8763,9765,9766,9767,8170,21364,8171,8179,8216,8225,8234,8416,8446,8453,8514,8515,8516,8550,8584,8618,8172,8173,8208,8209,8245,8277,8293,8294,8338,8354,8355,8382,8383,8431,8439,8456,8466,8492,8494,8496,8510,8511,8565,8174,8175,8199,8203,8228,8230,8240,8249,8250,8253,8268,8275,8276,8279,8280,8295,8300,8301,8311,8316,8334,8337,8339,8340,8344,8347,8371,8380,8391,8415,8418,8419,8422,8445,8447,8462,8473,8474,8477,8478,8495,8501,8502,8507,8508,8518,8566,8615,8616,8656,8657,8176,8177,8178,8201,8269,8307,8310,8324,8325,8353,8461,8504,8569,8591,8180,21142,21158,8181,8200,8215,8248,8278,8312,8318,8320,8330,8349,8360,8381,8387,8392,8398,8406,8420,8457,8465,8472,8479,8481,8484,8485,8513,8552,8585,8619,8182,8183,19443,8184,8260,8304,8185,8186,8261,8265,8267,8270,8288,8322,8336,8350,8411,8412,8480,8482,8486,8487,8489,8519,8553,8559,8568,8187,21240,8188,8259,8285,8335,8395,8427,8189,8190,8191,8309,8364,8397,8405,8192,8193,8194,8329,8333,8493,8195,8196,8197,8198,8202,8206,8207,8227,8236,8237,8264,8292,8308,8374,8375,8204,8205,8226,8262,8263,8274,8281,8282,8283,8284,8289,8290,8328,8348,8471,8538,8544,8617,8210,8211,8251,8368,8421,8548,8587,8614,8212,8213,8214,8321,8389,8599,8217,8218,8219,8356,8357,8372,8386,8435,8483,8573,8220,8221,8323,8222,8223,8224,8229,8231,8232,8303,8332,8467,8468,8541,8546,8551,8562,8233,8235,8238,21369,8239,8271,8297,8342,8396,8402,8430,8433,8434,8437,8463,8464,8470,8506,8517,8536,8542,8567,8590,8612,8613,8663,8242,21368,8243,8244,8247,8346,8367,8476,8488,8509,8558,8571,8246,8252,8254,8255,8256,8257,8258,8273,8319,8266,8272,8286,8296,8298,21322,8299,8343,8345,8429,8547,8557,8560,8561,8570,8665,8302,8305,35626,8306,8505,8313,8314,8363,8410,8417,8540,8543,8622,8315,8317,8326,8327,8331,8373,8376,8393,8403,8423,8432,8444,8454,8497,8503,8539,8588,8664,8341,30064,8671,8672,8673,8674,8675,8676,8677,8678,8679,8680,8681,8682,8683,8684,8685,8686,8687,8688,8689,8690,8691,8766,8767,8768,8769,8770,8771,8772,8773,8774,8775,8776,8777,8778,8351,8352,8359,8361,8362,8407,8475,8500,8534,8537,8597,8365,8366,8428,8535,8667,8370,8377,8378,8379,8385,8388,8390,8394,8399,8400,8574,8575,8576,8577,8579,8580,8581,8582,8583,8404,8413,8414,8424,8425,8426,8436,8440,8441,8442,8499,8554,8564,8443,8448,12253,12254,12255,12256,12257,12258,12259,12260,12261,12262,12263,12264,12265,12266,12267,12268,12269,12270,12271,12272,12273,12274,12275,12276,12277,12278,12279,12280,12281,28031,28032,34390,35542,35610,8449,8450,8451,8452,8455,8458,8459,8586,8460,8490,8491,8498,8512,8520,11735,11788,11792,11793,11796,11797,11798,11803,11804,11805,11821,19441,21299,20910,20911,21278,21279,21280,21281,21282,21283,21284,21285,21286,21287,21288,21289,21290,21291,21292,21293,21294,21295,21296,21297,21298,21300,21301,21302,21303,21304,21305,21306,21307,21308,21309,21315,21310,21311,21312,21313,21314,8549,8555,8623,8624,8625,8626,8627,8628,8629,8630,8631,8632,8633,8634,8635,8636,8637,8638,8639,8640,8641,8642,8643,8644,8645,8646,8647,8648,8649,8650,8651,8652,8653,8654,8556,8572,8592,8593,21340,8594,8595,8596,8598,8600,8601,8602,8603,8604,8605,8606,8607,8608,8609,8659,8660,8661,8662,8666,8669)) and ((`maniamall_cscart`.`cscart_categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`maniamall_cscart`.`cscart_categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`maniamall_cscart`.`cscart_categories`.`usergroup_ids`))) and (`maniamall_cscart`.`cscart_categories`.`status` in ('A','H')))"
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"maniamall_cscart.cscart_categories.category_id"
],
"rows_examined_per_scan": 19,
"rows_produced_per_join": 2577,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "73.04",
"eval_cost": "257.75",
"prefix_cost": "1137.14",
"data_read_per_join": "40K"
},
"used_columns": [
"product_id",
"category_id"
]
}
},
{
"table": {
"table_name": "products",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"maniamall_cscart.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 128,
"filtered": "5.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "12.89",
"prefix_cost": "1394.89",
"data_read_per_join": "563K"
},
"used_columns": [
"product_id",
"status",
"amount",
"usergroup_ids",
"tracking"
],
"attached_condition": "((`maniamall_cscart`.`products`.`status` = 'A') and (0 <> (case `maniamall_cscart`.`products`.`tracking` when 'O' then <cache>((NULL > 0)) when 'B' then (`maniamall_cscart`.`products`.`amount` > 0) else 1 end)) and ((`maniamall_cscart`.`products`.`usergroup_ids` = '') or (0 <> find_in_set(0,`maniamall_cscart`.`products`.`usergroup_ids`)) or (0 <> find_in_set(1,`maniamall_cscart`.`products`.`usergroup_ids`))))"
}
},
{
"table": {
"table_name": "popularity",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"total"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"maniamall_cscart.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 128,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "12.89",
"prefix_cost": "1407.78",
"data_read_per_join": "4K"
},
"used_columns": [
"product_id"
]
}
},
{
"table": {
"table_name": "cscart_product_prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "usergroup",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"maniamall_cscart.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 32,
"filtered": "25.00",
"cost_info": {
"read_cost": "67.12",
"eval_cost": "3.22",
"prefix_cost": "1487.79",
"data_read_per_join": "773"
},
"used_columns": [
"product_id",
"price",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`maniamall_cscart`.`cscart_product_prices`.`lower_limit` = 1) and (`maniamall_cscart`.`cscart_product_prices`.`usergroup_id` in (0,0,1)))"
}
},
{
"table": {
"table_name": "prices_2",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "usergroup",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"maniamall_cscart.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "5.00",
"not_exists": true,
"cost_info": {
"read_cost": "16.78",
"eval_cost": "0.16",
"prefix_cost": "1507.79",
"data_read_per_join": "38"
},
"used_columns": [
"product_id",
"price",
"lower_limit",
"usergroup_id"
],
"attached_condition": "(<if>(found_match(prices_2), (`maniamall_cscart`.`prices_2`.`price` is null), true) and <if>(is_not_null_compl(prices_2), ((`maniamall_cscart`.`prices_2`.`lower_limit` = 1) and (`maniamall_cscart`.`cscart_product_prices`.`price` > `maniamall_cscart`.`prices_2`.`price`) and (`maniamall_cscart`.`prices_2`.`usergroup_id` in (0,0,1))), true))"
}
},
{
"table": {
"table_name": "shared_prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"company_id",
"lower_limit",
"usergroup_id"
],
"key": "usergroup",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"maniamall_cscart.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"index_condition": "<if>(is_not_null_compl(shared_prices), ((`maniamall_cscart`.`shared_prices`.`company_id` = 1) and (`maniamall_cscart`.`shared_prices`.`lower_limit` = 1) and (`maniamall_cscart`.`shared_prices`.`usergroup_id` in (0,0,1))), true)",
"cost_info": {
"read_cost": "0.40",
"eval_cost": "0.16",
"prefix_cost": "1508.35",
"data_read_per_join": "51"
},
"used_columns": [
"product_id",
"price",
"lower_limit",
"company_id",
"usergroup_id"
]
}
}
]
}
}
Result
| min |
max |
| 1.24 |
953.13 |