SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509741 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509741 [ RunTime:0.002328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (963100,506576,762110,277191,1033477,249649,837233,739741,692478,427139,15882,702652,640823,556245,741137,191042,939819,812576,408519,847574,932774,98185,756043,864235,816148,1007073,446955,382013,131309,660163,55597,1040703,182525,797756,644710,1035907,128265,811493,455269,402735,816251,908125,56633,505460,588642,580078,672252,627024,584805,409924,636716,143367,218296,368295,276830,866946,394044,286523,86103,609671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]