SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557324 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557324 [ RunTime:0.003808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317251,810213,351035,914059,507293,533286,383227,109472,850115,183519,256339,590566,740765,427336,848553,969958,105087,224354,169961,10437,255770,71040,358503,795659,608536,701193,855661,123336,196585,748481,873801,343153,783324,169262,989914,601189,1018657,113589,71311,118971,481593,989245,280699,519138,890136,117910,206133,990742,866436,298300,921518,324790,604747,1000589,481485,916345,594900,201993,95983,756964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557324 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557324 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]