SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415232 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415232 [ RunTime:0.002200s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (213185,182930,1011396,802213,387320,451298,488414,17891,861024,148773,211296,231950,220315,159045,349618,781881,129008,800575,709927,1009325,278406,1010082,727397,627999,764747,154895,277313,985960,167445,821451,853380,415404,166760,223225,138923,99285,400893,628608,535206,814343,23802,369403,600065,286065,19873,516847,1047836,841351,819812,614741,48891,115286,355313,12391,988149,872505,354264,767269,267575,553756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415232 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415232 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]