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` = 306404 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 306404 [ RunTime:0.002141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607186,441599,688257,951641,734586,187051,600085,619711,975754,648381,992725,8219,535713,68247,178916,351910,42213,88334,177195,577930,846255,50655,274577,559188,560711,979338,280986,540870,844116,14833,289886,1015584,724,387327,1018505,851155,675070,13692,230135,968150,337659,740806,150164,664534,609908,190285,620610,207943,568513,1003603,229311,526371,778785,160147,605814,456949,358692,97330,998354,727932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 306404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 306404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]