SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038285 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038285 [ RunTime:0.002539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (716644,501617,863470,340253,448841,465052,671561,455487,735404,58550,665187,941124,15755,347040,133212,172097,438892,549828,566412,421400,66820,466572,272056,604607,1042197,56969,326527,544644,893966,560672,186963,868499,347493,142675,965323,691276,252156,617680,802109,1040331,1041459,916124,85391,708227,208347,736324,912447,924631,991120,581630,84360,458007,839327,554250,436815,180416,224915,612771,102938,553638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038285 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038285 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]