SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444291 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444291 [ RunTime:0.001553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180868,74740,883576,1013516,1046698,792726,975693,59064,888709,952991,377996,990074,719017,452800,813335,277144,839094,318067,146109,877036,511260,915361,19859,559741,158036,897865,460546,772761,875786,522636,11900,317822,271932,859516,585083,626658,409103,136717,554855,995840,67619,994208,950187,817015,888481,360870,742122,626086,892406,904304,727753,237518,730426,1047450,589427,561919,620487,667858,662994,1001926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]