SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356918 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356918 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420061,632504,256980,92361,356974,296275,874558,493558,363162,437576,410172,606803,909008,147351,99290,956283,396377,582701,135680,967682,1035141,7803,249993,895310,904725,447099,451823,368644,634337,648060,317386,946647,368886,194099,805124,549456,735395,1005760,142565,980883,859166,890406,887186,333828,1007058,277547,754428,20449,75148,171575,837937,212932,1002747,49311,612382,22663,864287,837691,1043960,650641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]