SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293331 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293331 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047072,625100,755773,631447,346928,15885,74294,984519,649312,538357,524982,646915,558975,278280,837311,387329,456223,774311,396205,315401,609300,820261,110816,434331,103217,254509,471834,1047807,368842,648237,136911,191521,4665,1014251,483804,813434,203379,620421,770024,59409,364098,294495,511350,86238,325472,911896,970905,306118,86935,412504,539182,546664,98263,594835,410815,197096,93644,377922,424835,357054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]