SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001589s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545393 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545393 [ RunTime:0.003494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840389,123420,110547,250947,66855,172864,366094,373306,721808,453583,995049,792305,271759,467859,20111,26930,192443,628735,640585,596639,984563,799973,302349,522505,932065,603039,872505,970660,1018088,52531,930577,1013432,1022404,263657,380913,606712,349810,356792,756118,697890,303154,41121,193973,992726,408463,715340,241641,973179,1048287,851259,312214,953774,158387,328433,915994,460287,936900,688497,869890,958685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]