SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010071 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010071 [ RunTime:0.002091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56787,464293,864270,522223,343059,165486,116913,772890,775459,740353,438637,842650,543943,119920,425519,20397,557212,218431,962831,609232,849236,1027901,600468,9854,889090,893299,613274,550375,818825,131712,101109,390285,145080,388824,120276,563061,1013994,809756,87788,642444,60128,251840,403793,278266,216017,659145,735362,751340,809133,314849,981810,450497,539062,779497,360467,297932,111432,589398,602798,569190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001805s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001810s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]