SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290315 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290315 [ RunTime:0.002466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315738,623858,199321,744569,192748,84878,28814,884742,361724,497597,146641,128801,499159,210641,136645,95859,983891,609640,324518,923084,226416,993915,569977,593358,319554,552334,107037,712990,508096,740798,295926,144442,125354,401846,698633,582071,240567,108034,67653,212911,871699,785659,3326,641049,5805,43414,451483,371592,949374,655777,1023841,769579,394133,368053,733638,267550,934078,917659,185881,774794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001457s ]