SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003996s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410057 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410057 [ RunTime:0.003258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417660,203197,474528,641417,152973,486959,457253,989512,457098,417139,788891,326325,440677,310775,384244,577809,585073,223465,473831,830313,195971,829162,184928,385740,581740,247025,495390,594056,482489,579713,219259,521755,824004,981390,525461,339217,190199,546835,883952,633108,654377,578980,188199,465576,909432,530788,29769,22998,440133,710446,879493,55791,45717,680644,500220,363477,674363,424330,195331,141938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001746s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002254s ]