SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501900 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501900 [ RunTime:0.001872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19086,196158,937704,92055,188630,744864,769998,119369,665156,128718,27573,398133,213098,3661,520201,880424,425213,647409,355055,92047,31614,862672,444833,416687,191192,581657,693571,360745,876804,734260,967253,800335,799680,508443,583781,192465,1026270,455776,197190,587735,315005,564095,695367,585963,570456,989017,990848,643008,1039902,578220,230409,207288,627258,430917,1043196,815305,243938,512683,4604,927866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]