SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486407 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486407 [ RunTime:0.002074s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97484,1043626,661951,549624,618919,635030,107593,6613,518172,508477,530037,930340,650440,401326,79067,150831,789994,983900,745314,865355,162142,904119,825732,463131,196518,1027705,411076,78624,1000072,797483,880113,596970,647273,760324,1033591,947108,885212,754428,120042,683897,138756,1000363,343661,930408,358499,273479,545277,1016937,902609,91792,331100,123984,545398,970783,253055,98290,968276,49800,210643,545975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]