SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001520s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802601 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802601 [ RunTime:0.001495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233672,681235,680445,929871,412388,439778,373238,301609,758105,390853,35528,864774,909793,392720,855955,387278,90571,126019,961953,623406,341874,744260,703489,471751,858390,872926,405744,940171,992922,269950,150681,760506,474218,1018133,464675,243976,142185,54430,444181,335704,839383,94430,1449,698931,371094,1025093,692158,888605,210291,1016654,383301,212305,593331,995259,794769,924290,704542,236411,159084,364959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]