Query time 0.02797
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "7.29"
},
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": true,
"cost_info": {
"sort_cost": "0.10"
},
"nested_loop": [
{
"table": {
"table_name": "dp",
"access_type": "index",
"possible_keys": [
"thread_id",
"thread_id_2"
],
"key": "thread_id_2",
"used_key_parts": [
"thread_id",
"status"
],
"key_length": "6",
"rows_examined_per_scan": 19,
"rows_produced_per_join": 1,
"filtered": "10.00",
"using_index": true,
"cost_info": {
"read_cost": "4.42",
"eval_cost": "0.38",
"prefix_cost": "4.80",
"data_read_per_join": "851"
},
"used_columns": [
"post_id",
"thread_id",
"status"
],
"attached_condition": "(`webmarco`.`dp`.`status` = 'A')"
}
},
{
"table": {
"table_name": "cscart_discussion",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"object_id"
],
"key": "PRIMARY",
"used_key_parts": [
"thread_id"
],
"key_length": "3",
"ref": [
"webmarco.dp.thread_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "1.90",
"eval_cost": "0.02",
"prefix_cost": "7.08",
"data_read_per_join": "2"
},
"used_columns": [
"thread_id",
"object_id",
"object_type"
],
"attached_condition": "((`webmarco`.`cscart_discussion`.`object_id` in (349683,356555,359422,357504,351887,356656,354756,355713,354511,349842,354972,358872,356249,349973,349661,351227,352595,354503,351863,349663,350115,352081,349883,352526,352200,351878,349776,351988,352076,351867,351913,352070,352520,351846,352066,351888,358690,351884,349657,355628,349662,355778,351993,352418,350003,351843,351869,351741,355851,351849,351855,352693,351852,352566,351847,351925,352074,352375,349686,352500,356187,351868,351278,352150,351919,350196,351881,351870,357137,349649,351918,351996,349656,355894,351839,352038,356543,351886,352017,354362,351914,351962,358758,351858,352684,351253,350117,349674,351429,351947,349650,352033,354338,351225,358640,351748,351907,352067,359080,358870,352314,351942,352409,351836,352084,357533,349685,351965,357134,356095,355083,351916,351830,350154,349867,349863,358373,351845,358937,356393,355907,351885,351989,349788,352408,351336,352608,351873,358896,354624,355828,352175,351871,350126,350132,355081,352031,355877,351292,352596,351872,350016,356539,350066,351778,356575,349858,351999,349688,352736,350022,351456,356685,354339,349892,357582,354325,352048,351825,358627,354349,351864,358668,352071,351938,358483,352054,351880,351882,350023,356229,350109,352143,351876,351917,352088,351257,352667,358497,356232,356535,350082,352181,351998,356391,352037,349949,356504,351950,355606,351955,352023,350019,350080,351890,351883,356552,351924,351992,349729,356620,351874,358416,351829,350190,349852,351859,351908,355004,350078,354441,349781,352203,354492,351877,351796,350050,355855,349927,352077,352161,351827,352152,357561,354385,351866,352406,349678,359082,349769,356483,350011,351826,355611,358762,351946,352044,352604,351789,352005,351991,349966,351777,356687,356414,356502,349703,354649,351994,352494,358864,352028,352041,352749,351948,354380,358269,352172,349699,350054,352737,352102,351828,355597,351810,351915,350075,357440,349817,351305,356540,349999,351794,351961,354442,358496,358780,357502,357496,356553,355646,349958,350049,351911,350170,357538,352499,357464,349675,356674,358914,356517,356335,350067,351738,356240,351606,352144,351814,352387,350121,354597,351848,352003,354340,352428,352026,349733,352492,352471,349731,351889,357498,351844,352740,355595,351943,355594,358406,358911,356216,355804,349873,349984,358760,349669,352696,359412,350045,352075,354604,355863,356302,352708,354707,351875,349982,354486,356126,359067,350182,355839,349693,352027,358915,352142,357634,351949,351624,351920,352011,349707,350184,357620,351439,355007,351764,351945,357526,358913,349823,349944,351909,351465,359009,351940,351997,352571,355840,351793,351923,352577,349845,352709,355838,350129,354788,355835,355002,356548,356013,358669,351912,355908,351231,356602,351420,354433,350002,349697,357557,352369,356267,351939,352141,351425,351921,358973,349764,358500,359406,351957,350024,358949,358487,358947,351964,349687,351963,352417,359075,352745,352197,350032,350081,356276,351865,358662,349848,356209,356576,351850,351941,356254,358325,349828,350059,351362,354425,355890,354342,358663,350101,351837,356523,356584,351929,357536,351325,351608,351960,354452,356336,352030,354806,356629,350065,352096,355986,356598,350004,352029,349989,356485,350195,354548,357534,359023,355876,351838,351851,352495,355003,356214,351857,358771,352063,358880,358969,352371,356208,349853,358975,349992,350187,355857,354327,349692,358633,358747,357579,354329,355873,358506,351954,352572,359092,355140,356530,355819,351833,351904,352742,354761,357636,354489,356491,356610,352207,356206,349763,359031,355821,351903,355088,352104,357578,349713,349832,351905,352581,352176,354505,356271,358518,351832,354351,351835,356655,352652,352072,354547,357585,358945,359008,356219,351861,351862,359423,352692,356562,349670,350152,356480,356560,354402,357556,349757,356497,356621,352078,352079,354653,352001,352610,352714,355651,356697,359088,356443,349750,354771,351747,352085,354417,351892,352021,352747,352146,355862,349789,351840,351559,354389,354382,354867,355599,357575,354804,351928,359076,349744,349701,352373,354400,358295,349734,352000,352559,358536,358989,352578,356669,349735,356694,349955,351936,350147,354802,351931,350055,349975,351831,351260,352694,359022,351554,356293,358797,351811,355975,356490,358559,350006,351944,352012,354360,359044,351270,351558,351799,349779,358433,354830,350094,352600,356382,358863,351932,352741,356696,349997,356644,349782,355923,352043,356547,357550,352057,352178,356192,352004,359424,352310,356397,358860,351409,352489,350142,351841,352451,354605,356567,352746,355841,358505,352218,354336,351337,354332,354418,356007,350167,351901,352035,356215,349766,356020,352042,352642,356117,351842,352083,355854,356538,350191,349889,356590,358399,352645,351307,351926,352002,352228,354445,355683,358888,349721,349737,355355,356278,358884,351272,359059,356468,350153,351952,355946,356431,350107,351238,351466,355700,356303,351234,354807,358492,358817,349722,354373,355679,358560,358837,350027,351780,351893,351956,355763,356235,349996,351902,354434,357552,349681,351891,352553,355767,350028,351230,356693,358368,352422,351326,351854,352173,355920,358883,351906,356635,358402,352338,355704,355858,352738,356044,358751,354602,349790,351951,355728,356512,358480,354811,355847,352073,352653,351935,354375,349813,354627,351432,351462,352739,354435,356045,352468,356477,356663,358621,358921,359089,352036,349716,356054,356596,356622,351953,351314,356338,358851,356682,351319,357466,349648,355935,357143,359039,351853,352496,358680,350069,354778,356473,351426,352331,351834,355868,356355,358667,351958,352617,354353,358775,351389,351930,352585,349910,352574,351379,351899,354387,357617,358694,349882,352691,349913,351287,350150,354617,351731,355715,351742,352437,356507,354754,359037,359052,354783,358995,359402,352345,349719,356649,351879,351224,354841,354413,354831,355909,356211,357135,355635,358712,349718,351934,354833,352432,352762,351959,352535,349986,351361,351898,351927,355996,356320,351433,355969,351267,351359,351422,351469,351894,352519,359017,358660,358646,351933,354397,354645,356330,359086,357630,351856,351995,349647,349994,354377,359036,349854,352620,351895,351937,354746,354968,354979,357546,349784,349891,351311,352223,352501,358841,356033,356107,354472,355677,356068,351728,351783,355697,355842,358358,351922,355093,355126,352095,354993,355963,352443,355688,357583,358786,351896,358600,354449,359042,355764,352431,352463,352678,356402,355633,351277,354481,356000,352630,349929,351570,349990,356314,358997,355106,351910,358998,357535,358493,355760,356086,351900,355730,356537,355033,358974,349808,358486,355103,354784,352120,351280,355934,358605,358753,358799,351803,352374,358776,351373,351782,355843,356084,354392,355979,355875,354500,355800,356101,357447,356449,358324,356093,351384,351255,351623,355794,357501,359069,351239,355050,358656,354620,355609,354408,352069,352722,351446,349645,350157,351819,355936,352090,356365,352464,356570,354411,351415,350046,358491,352222,355100,356025,352627,349646,357486,358529,350012,351584,354359,349651,355029,351338,352025,356409,358414,354371,355914,352194,352720,355118,358759,355057,358853,349993,350053,358575,352482,359084,350043,352589,355062,354406,358533,359005,358569,354459,355662,354462,351580,351736,351753,349717,354404,355756,351297,356071,352091,356528,355954,357133,354341,355693,352517,355980,356494,351755,352087,356225,351737,356222,358545,352211,356075,358830,351610,351556,352593,354403,350052,349857,349775,358385,356460,352330,351724,354603,349780,358917,358652,352448,355131,355770,350160,351557,356418,358825,354381,356128,352383,352086,355741,350168,354652,352162,352599,355743,350133,349760,349969,352132,358638,354998,356284,354622,349930,354623,351581,351604,354800,349727,349841,351812,352673,351773,352122,355038,355685,354618,350038,359420,350042,358508,352159,354762,355120,350119,352224,355686,352219,350062,350146,351788,352187,352748,354330,354730,355732,355803,351743,351787,352404,356678,350033,350140,351451,352546,349684,355758,352602,354641,356611,356572,352034,356561,349666,355121,355801,356334,349689,352179,349803,351785,354356,354608,356503,356549,352563,355891,351817,359077,352221,359016,351358,352505,351754,352040,358651,355090,356450,355754,356436,354638,349690,350183,355014,352587,349672,352080,355019,351243,357576,350125,350089,352440,350104,356385,358953,352590,355025,351242,351763,351802,354361,358507,358804,352050,354348,356368,350120,351784,355074,356081,359056,350197,352032,354335,356421,351765,351774,356030,350151,354455,358845,351416,352441,354799,355066,357540,358708,352390,357554,359421,356536,349844,355872,351404,359045,356339,350127,359414,356481,352089,357140,351800,357589,355021,350001,356522,355883,355116,355995,351241,356262,356546,356686,356227,356290,351279,352117,349827,352580,355659,359078,350064,351734,354326,352421,352760,355043,352433,352666,355107,355998,356636,358530,359013,349660,350169,351966,355941,354383,354776,356129,354355,352700,354647,355736,355639,349702,358553,355911,355812,354708,356092,349902,352301,354366,356551,354390,358744,352182,352438,354333,358698,349916,351739,351990,357439,352662,355101,356088,351367,352098,358570,351308,349917,358879,352124,356096,350131,355006,356270,357701,357445,350018,351366,349951,351735,351569,352093,356324,350138,351364,351568,351760,354977,349829,351417,356628,349770,349860,351543,354334,354700,356052,356438,351577,351808,356673,358950,351746,357511,352139,354703,355703,356369,349884,352570,358957,349926,349804,352509,356688,358645,352654,352531,354789,355820,358601,354630,355005,355072,351897,352400,350079,355928,354981,355079,352447,352729,351733,355905,356660,352051,355814,358778,349774,349677,349807,350013,354760,356398,355837,351745,356394,354358,355808,351749,356281,352324,353115,355626,352220,352576,354824,355724,349885,356113,356577,357588,356550,350083,351315,351561,352544,357448,358332,358978,350000,351453,352753,358718,358982,349659,351601,355802,352068,349983,351752,349691,351443,352010,352450,352565,352695,349979,352703,349806,351390,352046,352743,355797,350174,358527,352609,352039,352638,356509,349743,351383,351786,358959,350034,352430,349864,351572,349964,351744,349655,352055,352536,352659,356407,358546,350073,351750,351795,352569,350058,350134,351727,351756,352539,356455,349798,356484,352094,352361,349787,349866,354367,355028,358658,349928,352398,351588,352725,350048,351759,352196,349712,354436,355123,352309,355945,351583,354782,358691,351824,349942,359029,350110,355958,356453,357458,351252,358452,352402,355896,349865,351860,357489,349710,349814,349980,350118,350156,352534,354615,357425,357495,358972,352045,354780,351757,352513,354794,349791,351251,352195,351455,356074,358875,359073,349906,351310,356264,356482,352140,354514,354614,357580,351376,359397,352052,355805,350005,351293,354790,355774,356588,349937,352123,355765,355880,356191,349977,354646,358916,352047,352311,355030,351463,352024,358711,349705,356591,355789,349783,349839,351597,352674,357506,358581,351431,352214,359062,349952,351460,352668,356223,350175,351244,351233,354826,351614,358311,350087,352416,355904,356389,357637,352125,352160,354598,349954,356332,357449,358904,359003,354331,356487,358843,350193,356489,354772,355145,358554,352396,355647,349940,350061,351768,351770,352226,356508,357559,358417,356300,358898,351365,356260,356600,358484,349894,349914,350071,351585,355772,356625,354773,350015,352397,352407,352710,355665,358716,351381,352174,356384,356627,350031,356186,352434,356439,356519,359047,350076,352202,356427,351776,357610,358971,349652,357624,358871,351265,356308,356525,349870,349893,349742,350056,352341,356085,358992,351281,355897,356406,349704,349809,352205,350166,352131,354706,349880,352376,355773,351322,356589,358873,352099,352302,351418,349923,350111,358277,354625,351611,359068,352665,352537,354363,358809,351617,350070,350186,354803,355718,355881,356578,349861,351729,350105,354350,352060,352410,352669,349998,356659,355738,351586,350165,355810,358865,349869,349665,350014,356252,354542,357635,352399,355044,351790,356257,349843,351440,357507,349932,356261,349658,352606,356379,357430,354494,352493,358562,352015,352062,356501,350051,354814,352006,356542,356700,358779,359033,349706,352312,355831,356419,352734,354835,355625,351400,349773,349838,351766,352759,354774,356299,349931,352299,356380,349709,351593,351762,352082,358951,357529,349881,350008,350084,350149,352728,355135,356256,356648,356668,349797,350176,350189,351299,351331,352303,355144,356516,357593,359083,354786,355084,358970,349985,350007,350163,351306,352439,352607,352718,354775,356554,356677,358513,349667,352019,352022,356518,350037,351355,352049,356285,349991,351467,352136,356657,351428,352751,358839,352584,355016,355610,356557,358419,350124,356698,349726,350122,351781,352092,352153,358514,355739,349673,353116,356500,356599,349965,349968,350063,351822,354984,355013,356454,354501,351779,356190,349962,350158,351356,355783,356041,358501,352750,352151,354504,356626,349847,349862,349868,350091,351232,354364,351229,352101,357499,358613,358653,349785,351296,352381,352547,356188,350162,351587,358897,351553,352020,352633,358940,349970,352186,355122,359081,349668,349849,352145,354735,352105,354543,355630,349821,351228,352018,355085,355815,358952,349950,350144,351544,356295,356403,350072,358590,352097,355895,349961,351427,351555,354391,349888,350090,355749,355823,356087,350085,352686,356637,349777,351256,352579,356513,352527,354643,356042,356579,349753,351571,351240,356614,350077,352137,352551,349871,351452,349767,351809,350136,350155,351767,352138,352377,356642,356666,349948,349971,352752,356301,352385,356333,358666,357549,354757,355846,358551,349728,351320,352677,359404,350141,349855,350143,351726,349850,349936,352538,355784,356226,359007,351582,352685,356236,349967,352533,355870,351410,351579,352128,352208,354791,356690,356498,359070,349846,351339,355906,358936,350192,352545,354471,355864,349786,350036,350173,355913,359032,354640,349730,352059,356496,356505,358935,350135,351797,352412,352177,356258,359051,350188,351449,356662,349956,354863,355806,350017,351563,351574,352163,354792,358522,349792,349921,352103,352502,352529,354991,355879,356456,357808,351740,355001,355912,356014,352305,352637,352689,352690,355882,349915,352498,355929,356563,351412,355781,356499,356658,358948,358966,349899,354731,356609,358692,349799,349840,354834,350040,350172,356647,351363,352147,355796,356378,356520,349778,352711,358630,358741,349758,349802,355795,354544,349746,349872,352755,354495,355922,349708,349976,350128,351567,358297,349909,351596,352372,355874,356097,356250,352053,355721,358489,351816,352183,355893,356462,349934,351619,356331,356585,357500,349755,351565,359066,355015,358435,349978,352392,354651,349805,350178,352525,355755,354621,349654,350041,351275,354759,349957,351343,356079,356199,357587,358665,349810,350074,352199,352488,354521,358440,351250,351605,356492,358537,352370,351288,355008,356189,358743,350068,354758,355608,358354,349981,350035,352135,354848,355892,356595,358876,351566,352395,354520,356337,352658,354513,354871,358657,350100,352401,354328,359079,349886,352603,359087,352363,352478,355650,358739,349895,349901,351332,352405,350103,358693,349768,352459,355775,358806,349698,349876,351411,357581,352511,352522,356064,356605,358869,355017,356202,350025,358534,350088,349833,350171,351402,354506,349680,349725,354798,349907,355664,356247,358787,352106,354704,355848,359020,349741,354971,358977,354345,355596,356399,349859,354810,359090,352629,355777,352188,352698,354805,354819,351374,352636,355670,357446,357577,351772,358858,350159,349720,351575,351539,355824,359407,351821,356415,356638,349933,349935,349945,352391,351344,352201,352490,352650,352764,354512,356370,358715,350021,352198,356386,356430,358307,349898,351430,352190,354701,359030,349995,352744,355780,356231,357592,358639,352598,350009,351459,356568,357438,358330,352444,352697,354857,356269,349676,352649,355836,352056,352065,352552,358928,352127,352628,357428,351437,351542,355833,356286,349851,350020,350181,351464,352635,354829,356381,358306,352506,352726,354750,350116,351564,352413,354519,355832,355988,357132,357595,355598,355790,356574,358672,349947,352116,358524,356221,358495,350092,357505,358654,351290,351353,351607,356445,356298,359409,355128,352481,355666,358874,352663,354626,355887,356613,351309,352009,352420,356434,359034,349900,351345,352550,358979,354629,356297,349794,350185,356233,358329,354812,349771,356305,356653,358469,349911,351419,351732,352158,357809,349664,349800,350044,351609,352639,355040,354864,355807,356559,350164,351289,351294,352107,354518,355076,358521,352384,352648,357451,351578,351613,351798,352121,354650,349715,349739,351393,351552,352234,352735,355884,358418,358470,350123,355885,354836,355663,358757,351341,351758,352126,352193,358344,358980,349756,349819,356109,356114,356641,357494,358387,349653,349714,351589,352155,356195,351298,352154,355869,349749,349938,352100,352640,357145,357798,351346,352014,352411,355039,357491,358479,349904,352118,355809,357532,358516,351751,355139,355853,356130,358375,349740,351236,356583,356639,358713,358859,351223,352425,354609,356263,351372,351549,351813,358732,349732,351625,355886,358678,351761,352225,352347,352465,354343,356689,358735,349875,351313,352308,354516,355888,356287,357590,358478,354421,356675,358312,358421,358567,350057,351622,352185,352300,352449,357527,349918,352109,352204,352634,352681,354628,349922,350139,352209,358671,349912,352129,352380,352503,354827,351562,354755,356388,358919,355925,356135,350039,356361,358318,358934,351350,354443,356672,355985,356237,352632,352688,352732,355865,350148,354496,349671,351375,352013,354999,355867,356532,357490,359048,350099,351226,355130,356230,356440,352008,349700,355627,356461,356565,350086,351254,351414,352130,354502,356205,357457,356683,358298,358439,359021,359408,349738,349919,356429,356573,357497,350108,354599,355649,356458,350180,351246,352660,356665,351348,352114,352165,352192,355968,356437,356470,358924,351590,351282,352119,355971,356115,350145,352058,352180,354975,356239,359024,352164,352210,355636,352763,356016,356428,356545,349824,350130,351573,352168,352483,358962,356654,351535,354705,355902,349679,350047,358629,359094,351317,351333,351291,351316,352171,352687,354600,356311,356558,351450,352518,356681,358296,358764,350112,351245,351804,352532,354596,356309,349695,349877,352156,352366,352562,352757,356251,357539,358392,358454,358954,349765,352497,356277,358499,358557,349878,351615,354753,358308,358700,349897,352394,352342,357508,358396,359025,356283,358357,358761,349946,352484,352646,355900,358317,349879,352321,352474,352657,354817,358515,349818,351328,354976,349972,352473,358449,358596,359010,352487,352568,355037,355829,356196,356400,358548,355631,356273,356527,349874,350137,351276,351335,351537,352549,352564,355137,355816,356371,357591,351775,352304,355714,355860,355921,356452,356684,357138,352346,355791,356207,357512,358930,349903,351536,351545,351801,352016,352733,355671,356265,356463,356541,356695,351401,352133,352601,352644,355901,356564,358388,351560,354702,356313,356451,357618,349834,350026,350060,350102,351791,352007,352112,352167,355657,349941,352061,352605,356353,356556,358519,351258,352452,352462,355000,349811,351342,351528,351621,354832,355065,356098,356479,358683,352206,352335,356234,356612,349796,351454,352189,352336,354470,349801,350177,350194,351533,352191,354850,356275,356343,356420,357638,358437,358699,350095,355878,352542,355817,356224,357450,359401,349762,351368,356447,351295,356544,349815,352365,354974,358447,352415,352524,357429,358394,349682,352215,352216,352651,354365,354515,356218,349820,351271,351616,352403,355799,355012,356047,356623,352575,356493,357614,358828,356294,356376,356645,358677,358900,349924,352334,356094,349837,349925,352115,356255,356259,350029,352389,356023,352326,352419,354809,355070,356228,356587,357797,358390,358441,358566,349752,349987,350098,356459,358535,358734,359403,351330,351541,354642,356472,358899,351815,356099,356392,356506,357596,355731,357584,359035,351548,351612,356566,352170,352647,354873,358750,358941,349836,349890,357633,349887,350097,352157,352184,355720,349694,349751,349856,349908,352148,354734,356246,359413,352113,354768,356351,357594,358356,358423,349939,352530,354694,356306,358670,355648,349772,351312,355793,356248,356643,358556,349736,349943,358420,355716,351470,352364,354432,354737,358745,349826,352111,352597,354793,355136,358867,359065,352613,354825,357476,354601,356325,359419,351436,352333,354866,355987,356197,351538,351595,354545,355124,355811,358485,358866,349896,351591,352307,355889,352480,352507,356296,356615,357642,358415,351551,355742,357553,359053,351448,352528,354847,355899,356640,359091,352724,354785,352671,358340,352149,352672,353117,357503,352217,352560,356354,356586,352556,355069,355667,352670,349905,356488,358706,349816,351266,352110,352212,352475,352344,352504,352721,354787,355097,355903,355937,356238,356448,351347,351354,351820,352134,352727,354376,356478,358976,359011,352476,352557,352594,352756,357555,350093,351540,352656,358520,359063,352213,358968,351600,354372,355825,357510,357514,358552,349812,351529,352641,354428,355600,358960,352230,352713,356274,359411,352169,354384,355898,357811,358717,349825,349974,352108,352316,352661,352716,352717,354337,354426,354619,349723,350161,351269,352166,352313,354639,355830,356204,358393,358498,349822,352516,352623,349959,350030,352523,352676,355102,355699,355834,358832,349920,350113,352704,354987,356292,356630,359399,349988,351472,352064,352354,352466,354813,355009,356272,357437,358767,351387,351730,352348,354777,355045,356646,357492,358517,358664,351603,352541,354751,357560,358391,356395,358442,351441,352337,352515,354493,354752,354816,355134,355953,356360,358892,349711,349960,350010,351618,352491,355672,357551,352424,356446,356594,357477,352540,352715,356282,356307,351329,351391,351725,354797,351357,351369,351527,351547,352379,352758,354412,354839,355813,356457,357455,357484,351388,352512,352558,352612,354828,354870,358331,349831,351340,352317,352548,352573,354394,354396,354509,356280,356390,356524,356650,358942,351321,351394,351442,356580,357597,358341,358370,358573,358768,351385,352332,354508,354875,355125,355725,356377,358538,358792,358939,351283,351351,351382,351408,352378,352699,354745,354855,355141,356193,356253,358319,358684,358709,354616,357431,357471,358310,358580,349830,351235,351550,352470,352592,355735,358523,349696,349793,351461,355932,356531,358386,358738,357444,357625,358729,354973,354978,358993,354845,356310,356671,358895,352368,354507,355681,356699,351237,355018,355655,357799,358782,351438,351530,352761,354388,356212,356412,358328,349724,352232,354395,356243,349754,351457,354444,354497,356242,357548,351421,349761,355733,358488,358547,356571,357488,358938,351247,352707,358587,349745,357493,352521,352583,354431,356679,358885,351397,351399,351531,352355,356486,349953,352731,354865,356569,351392,354795,356046,356404,356593,358543,359046,351407,351805,355974,359019,352306,355723,358460,351318,351334,351398,351424,351447,354405,354838,356661,354415,355850,358359,351576,351602,359028,351286,352445,352554,352754,356363,357136,357524,357611,358395,358877,352386,352393,354416,357522,358320,358730,351445,354347,354767,355856,358384,351377,355661,358477,358540,358637,351349,352477,356003,356241,356526,358695,351371,352616,354837,355026,356383,356426,356680,352680,354344,355656,355717,355719,355938,358769,349759,351301,351818,352701,358389,358438,358544,351546,349747,350179,352231,354808,355142,357144,357567,358789,351261,352327,355919,357569,352588,354456,356619,357427,352359,354815,355669,356220,359418,352325,352382,354369,354423,355726,356210,356291,356651,357632,352567,354491,354747,355645,355792,358361,356604,357139,358593,352458,352469,354607,356432,356624,357525,355629,358397,351599,354843,351249,351304,352543,357613,352683,355108,355632,356416,358628,359405,359054,357537,357544,358444,352356,355734,356341,352414,354631,354781,356073,356601,357454,351405,351413,355918,354453,354463,356387,358644,358800,358326,352322,354878,356691,357640,351406,358510,358614,359417,352611,354779,356652,358376,352712,354982,356323,356616,358403,358632,358724,358727,358773,354872,355011,355822,358583,352423,352555,352621,352643,354749,354967,356444,356582,358836,359006,352367,352626,356076,356401,357513,357530,351259,356581,357441,358434,352318,356061,356268,356521,357586,358503,358604,352485,351324,351771,354733,358886,356116,352679,358829,351352,355779,355827,350106,355910,352320,354732,358833,351302,356010,358887,355991,358956,358378,351444,359026,357608,358398,352436,357810,355722,359072,352227,352508,354480,354510,355970,355993,357523,357602,357619,358579,351264,352730,356124,356374,356411,357480,358850,359071,356510,358426,358502,358932,349748,351284,351434,356529,358673,351303,351823,352349,355099,355127,355917,357141,351471,352351,352675,355762,357452,357485,358781,350096,356112,358526,358793,358943,359398,351594,355782,355073,355965,356031,356132,357547,357800,358725,358728,358733,352388,355105,355660,356213,357601,358422,358925,358965,359061,358990,349963,352343,352582,352618,354368,354386,358446,358473,358704,358721,358891,356464,358490,351360,351273,355082,355944,356027,357465,358641,352655,358400,358901,351620,354613,357142,358369,358826,352229,352514,354424,354429,357436,357453,357528,357598,358801,350114,354354,355753,357812,352323,352353,358958,351370,351386,351396,351532,352510,352624,355020,355133,356082,356425,356676,358599,358840,352233,356667,357467,358275,358382,358408,358457,351598,352358,352615,354985,356289,356511,358991,352429,355042,356592,357463,358831,358984,351403,354763,352319,354856,355668,356100,351323,351435,352362,354450,354648,354877,356424,357146,358432,358620,358920,351473,352591,354399,354517,354644,354769,355061,355086,355676,355678,355747,355951,356002,357566,358380,358811,354970,356603,358849,352350,352586,355053,355698,356050,358462,358882,351285,351474,354440,354862,355612,355852,355866,351263,351792,355966,356317,358603,351458,351592,352446,354448,354488,354876,355041,355049,356417,357469,358737,352461,354352,354398,356029,356606,357442,358740,352339,357616,358374,358961,359004,351222,351395,354478,354546,355642,356413,358819,354868,355684,355994,356080,357807,358407,358586,355818,355997,356053,352631,354447,356203,356329,357615,357796,358591,358636,358765,358854,351268,351300,351378,355602,355931,356467,356617,357628,358309,358756,359093,359415,354346,358270,358509,358589,351327,354458,354986,355094,356348,358443,358525,358785,352315,352479,354490,354766,354869,355690,355737,356019,356051,357571,358316,358431,358574,354851,358592,351806,352298,352486,352561,354401,355075,355696,356200,356244,356245,358379,358436,354419,355032,355035,355067,355849,355984,356058,356105,356288,358360,358790,358983,355607,356103,356118,358363,358364,352329,354420,355652,358366,358803,358964,354477,354522,354980,356017,356060,356198,356217,357627,358467,358598,358835,358944,358981,352467,355010,351534,352702,354487,354842,355023,355605,355967,356039,356106,357478,357641,358322,358594,358674,358736,351807,354422,354874,355787,357520,357609,358271,358808,358963,349795,352719,354610,355117,355942,356422,356475,358327,358642,359015,359410,355933,356032,356318,356597,357472,352435,354860,355114,355788,356279,356319,357433,357643,358541,358612,358746,359055,352625,354846,355751,355961,357443,357543,358616,358755,358857,358878,358985,352622,355087,355138,357558,358448,358461,351468,352454,352457,354430,354606,355687,356037,356104,356664,357473,358766,358855,356322,357521,358602,358783,358810,359040,352360,352614,354407,354466,354796,355798,357629,358428,351248,354409,355112,355654,355960,355964,356065,356072,357487,357570,355744,356055,356469,358682,359064,354485,355098,357639,358355,358796,354765,355110,355680,355769,355948,355990,356347,357460,358466,358742,358929,352340,352456,354438,356125,356631,358377,358999,354840,355977,356136,358313,358512,358688,351274,352357,354427,354461,354744,355658,355674,356328,358558,358931,355054,358685,354468,358365,358697,354632,354852,355644,356131,356433,358847,358889,355950,356028,356040,356049,358634,349835,351423,352352,352442,352619,354460,354995,355710,356062,356127,356133,358342,358619,358675,352426,354393,355063,355981,358427,358844,358987,359038,354820,355109,355776,358910,351769,352460,354410,354498,355060,355096,355111,356396,358814,358842,354379,354854,357462,357475,354844,356008,356119,351380,354457,356342,357600,358597,358701,355055,355926,358424,358445,358474,358582,358696,352664,355089,355844,357574,358410,355692,356036,357568,352705,354484,355959,356022,358463,358726,358788,358856,358861,356304,358846,354736,356005,356670,358774,355104,355861,355871,358815,354996,357474,358795,358955,355748,356004,356122,355712,358563,358626,358412,358476,354439,355022,357456,356043,356366,356515,357604,358902,356410,356533,356534,357603,357803,358539,356070,358494,358615,354446,355859,357605,357816,358549,358763,356692,358383,358994,357814,354861,356266,358608,358676,355978,356194,357541,357542,358631,358777,359043,352472,352706,354801,355078,355682,356359,356618,357519,358710,359060,352682,354990,355119,355785,356465,358655,358705,358794,358918,354748,358624,358643,355689,355707,355709,355786,356018,358719,358933,356069,356423,358528,358687,358481,355601,356001,357801,358748,354858,355024,355027,355706,356120,356123,358661,356102,355673,356435,356634,358648,358752,352723,354818,356012,356340,357612,357806,358429,358459,358807,354467,355115,356442,357509,352328,352455,355059,355603,355643,356089,356201,357515,358827,358908,359074,351262,352453,354464,355056,355740,356024,356067,356633,358542,358824,358996,359058,355915,357517,358607,356608,358405,359400,359416,355080,355771,356077,356121,357147,357483,358565,358618,358893,358927,354983,357434,358367,358371,358905,354611,356038,358813,352427,354821,356034,356321,357482,357545,357802,358561,358588,358623,359027,354414,354469,355983,357459,358451,358475,358550,355031,355091,355999,356035,356466,357621,358611,358731,358923,358401,358812,354479,355034,355955,358425,359001,355077,355989,356057,357805,358272,358482,358686,358798,358802,358821,356350,358647,355826,358770,358805,359057,354853,355113,355641,356078,356083,356110,356364,356408,358571,358720,355702,358852,358926,359014,358568,358822,358834,354997,355653,356315,357435,357572,358472,354465,354989,355143,355640,356632,357516,358458,358702,354451,354357,355036,355766,355916,355992,356327,355924,355962,358576,354476,354709,357606,358595,354374,354482,355604,355637,356134,358464,358504,358714,358848,354473,355048,355727,356326,356352,357432,358823,354483,355973,356026,356056,358456,354859,355064,355695,355952,356015,356137,356441,358404,358450,358471,358531,358555,358273,355634,355701,355949,356375,357479,356091,356474,356495,358465,358772,358967,355052,358890,355711,355746,355982,356345,356358,356476,357599,357631,358468,358584,358585,359012,359085,354969,354988,355708,355768,355927,355930,357481,358622,358659,358722,358791,354475,356607,354992,355058,355095,356009,357426,357623,357815,358577,359018,354764,354823,355092,355845,356405,358430,358868,354822,358881,358912,355705,355757,355943,355956,356138,358274,354454,355745,355947,356356,356471,357518,357607,358323,358409,358532,358635,358784,358909,354849,355694,359050,354378,355750,355940,355972,356059,356063,358679,355051,355068,355071,355638,357804,358838,354370,356048,356021,356312,356349,356362,358986,355047,355132,357461,358314,358606,358749,359000,355761,358411,356108,356357,354994,358455,358707,356006,356011,358362,358894,358906,356111,357813,359041,354437,355129,359049,358413,356346,358816,357470,358372,358381,358649,358609,358988,359002,355939,358625,358689,355691,354474,356373,358862,355957,358650,358723,358946,358703,355976,358818,354770,355729,358578,358903,355046,357622,354612,354499,357468,358315,358453,358820,355759,356344,358572,358922,358321,358511,358564,356372,356514,357626,355752,358907,358754,355675,358610,358617,356090,356367,358681,356066,356316,357573)) and (`webmarco`.`cscart_discussion`.`object_type` = 'P'))"
}
},
{
"table": {
"table_name": "p",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"age_verification",
"status",
"idx_parent_product_id",
"idx_master_product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"webmarco.cscart_discussion.object_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.10",
"eval_cost": "0.02",
"prefix_cost": "7.19",
"data_read_per_join": "760"
},
"used_columns": [
"product_id"
]
}
}
]
}
}
}