SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503383 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503383 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59147,209391,312411,834650,665687,617125,1038382,729690,65090,575881,1014585,431554,381699,341846,413039,550878,469160,1017819,998570,652565,1027120,997659,32032,1009946,716363,392900,727098,688851,655261,846937,10988,38773,335957,141714,155034,217695,888366,261078,244480,351964,77101,967381,940135,595913,125853,136940,208744,8337,63742,32871,648027,424785,156569,736005,139621,838920,232496,985690,553141,114251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000861s ]