SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338179 LIMIT 1 [ RunTime:0.001289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338179 [ RunTime:0.002984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340039,213564,27326,647004,890489,71626,762123,178305,679246,551582,379180,559480,172675,481634,789203,1019288,822534,939418,46264,45260,591534,1034570,175239,955099,932526,788364,270618,224505,625096,65829,450332,430302,1037933,981811,1020790,552339,595560,506101,203997,922130,269017,695815,203968,300148,423092,648344,595516,147862,408769,757154,763114,281328,627476,383025,566439,141237,375918,238526,378089,215765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]