SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106254 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106254 [ RunTime:0.003716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354225,401861,274630,516664,554134,122666,723586,162029,629265,215005,380644,311163,718812,580606,913881,315426,304442,122060,1041617,765765,808351,1009523,540689,362514,134273,906867,488118,148072,408268,634024,403883,433925,368191,511466,191443,907937,556311,115025,74623,999287,351049,596433,717218,241412,691473,363237,613241,461302,155217,604139,264920,348058,228105,100388,143664,765955,292138,972300,513101,774842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002217s ]