SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106731 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106731 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542103,571712,174296,981361,172009,720210,928515,454908,612506,116808,194249,107191,430221,111073,534102,329754,396230,662371,992643,15241,835579,467107,765274,124155,646143,263915,731048,919152,578199,607007,1024590,844565,66917,863724,280872,202517,593847,1004919,513488,204160,495836,1004577,116922,35068,347680,702387,905630,989307,202894,861496,117733,648049,505922,157235,941296,42265,481618,616567,510602,492398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014822s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]