SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527543 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527543 [ RunTime:0.002518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010382,47434,837566,11321,894917,529939,498914,549823,995446,868751,567525,685039,558186,995201,725211,68210,600686,609935,889508,376576,995868,433207,972068,211898,287105,1026274,780418,713082,419042,160037,598720,427396,123046,134908,53713,905597,944235,777042,420464,106639,965222,200193,539900,96609,110985,258821,470099,718427,160020,1002400,194431,600238,916803,523255,979552,186119,204815,963734,900223,203007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]