SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412879 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412879 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416515,645360,520798,199546,543,407593,737408,214140,292587,96145,1034284,308571,542418,982855,605538,217421,359823,1016649,705896,611629,106993,438240,986775,1001109,567507,73384,825063,1029241,1012539,90902,482925,393335,279765,129008,241431,399061,892526,152735,943233,1027143,439885,246836,953431,396120,703036,879068,215234,967749,219281,276042,611923,201750,401736,93288,321232,6587,964101,430849,376946,989206) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412879 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412879 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]