SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43328 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43328 [ RunTime:0.002264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216104,454181,966140,540634,621404,649627,1033947,555008,910514,53726,930343,84251,201553,999493,1019321,983392,393961,813483,809344,781941,397796,570752,876248,611881,66966,20432,503166,900416,771223,932335,666265,612678,1669,514859,743916,1027152,306616,68967,386586,131661,91568,551562,754156,210945,759459,623340,431993,696844,697080,388064,814125,247743,562630,726631,139400,492819,904027,798912,629075,476687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]