SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400683 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400683 [ RunTime:0.001962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66471,290250,976865,199863,831401,233229,4744,406326,605881,413339,614351,945078,698263,1018559,832390,787317,879171,471349,729249,119724,294884,613625,656129,77442,882040,651657,487439,396336,1019921,668991,442151,971891,140598,195585,992005,935802,764948,489480,347874,842786,300453,1005954,839243,739457,322705,515990,106375,459499,408260,99689,836023,783953,396891,690786,640657,841376,568267,538507,508630,1002694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]