SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 684699 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 684699 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280571,16528,952393,1039623,996392,508839,551957,1037756,300332,5328,760622,876640,599084,835246,909190,330338,778886,584406,46319,299021,455242,740628,686586,118326,530704,800929,454657,961012,1031800,981642,954633,482073,947156,499756,450322,693708,634000,592914,19193,204077,821530,623916,783068,75583,224377,521037,290815,460668,789203,769321,319310,272401,1044558,953066,757675,19135,717789,39991,568449,1026152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 684699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 684699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001340s ]