SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575743 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575743 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (898204,1010537,360756,423569,820283,292420,219613,968829,127719,351673,905192,294301,214858,780619,545269,232742,209025,844477,960055,173692,54458,583562,345985,747411,122167,223237,28986,587979,752134,497533,573116,356569,580249,884759,223448,358989,287315,692105,426235,490529,261385,476009,740747,297116,719360,657606,330756,434036,446156,849604,24250,465590,33770,94087,906703,363358,84348,670179,489292,797305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]