SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105883 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105883 [ RunTime:0.003699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621951,171977,294345,75141,77833,203013,16326,420554,891286,39784,454091,799427,1034993,236398,265629,759079,92864,621126,260176,776385,524718,128018,194517,556883,440386,999174,95784,532476,1046247,720371,194540,406619,14457,7943,413503,556391,759734,776880,464299,282012,922084,713733,753178,588756,543846,458917,58248,653781,370854,604252,1007569,367843,575608,900010,964002,1048714,611679,1007133,519362,643350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]