SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031417 LIMIT 1 [ RunTime:0.001339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031417 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398206,739327,680050,695744,10311,681760,269090,724391,552494,351357,1020515,66199,615460,377385,615988,383520,95175,918379,815180,202023,707375,156796,884415,347345,556217,335715,774967,873055,602016,545872,216458,181736,296494,380114,58855,143144,217794,961531,1005604,852361,873883,668276,818293,559700,556310,388260,779064,296571,739353,725324,72211,20328,709604,30764,83283,943515,540933,366619,505227,695333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.027266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002437s ]