SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567516 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567516 [ RunTime:0.001925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260582,128061,168335,753768,471463,434852,933502,149342,845005,859206,343012,102827,280238,542323,624339,475087,174675,987096,683163,533249,860872,997296,30669,38730,574943,694636,95823,300292,395522,1007619,1017356,975843,526436,838580,262637,932164,722151,385321,13833,659389,56074,193754,125632,710306,86801,840884,915147,902392,976627,541448,921326,1002968,908001,121772,450128,9549,489733,846070,519907,63932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]