SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34008 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34008 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117845,113771,186414,744418,709513,725874,1018906,793898,109515,782961,10129,445335,226507,356892,199760,24384,147227,916553,284311,325313,958584,296064,756320,628339,175544,404826,694371,591970,193630,658199,20518,547065,465340,548433,456063,729598,669074,918074,202840,646390,252315,64141,725536,65858,362558,305538,218839,661192,278405,62359,180365,197417,213812,694249,726820,987235,211215,971166,819866,156659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000871s ]