SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 151180 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 151180 [ RunTime:0.002111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236679,703726,355733,768335,168237,212445,704410,864939,1048350,62755,899457,722881,84779,989765,331025,198062,837468,981076,14761,775634,701912,391056,183176,1047515,316871,27634,820956,75986,603999,200409,146853,334694,448486,597924,580234,807718,266581,621796,837013,233043,879898,283355,850072,960873,82175,455311,973250,841915,835788,1022814,991486,269896,319943,480362,1001666,409776,873139,651135,220639,256393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 151180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 151180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]