SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397838 LIMIT 1 [ RunTime:0.000913s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397838 [ RunTime:0.002437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383515,100874,627042,143432,294342,508859,839719,187313,998562,1001195,41800,23415,687365,875012,207219,73889,234314,236402,988080,584676,716210,803904,655392,682688,161984,621668,488772,527025,902393,121027,697913,593434,104705,135299,714836,334267,154076,239322,700916,694092,755154,859408,653340,99535,166196,180753,490907,1047468,965067,555246,786547,665325,865891,299054,119754,487,793161,158694,157351,934831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001653s ]