SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023108 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023108 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640614,689592,118188,590366,90706,518036,402368,802446,437872,349788,357401,491908,404702,290217,41249,82203,1001214,334025,221213,665954,628723,729392,744880,676641,303111,102247,854101,368884,579626,884550,732022,161389,16464,902020,845153,730407,582986,770795,295658,633561,991446,216073,1045292,112093,815128,924149,330691,271768,269506,235192,473360,665978,492450,634217,196996,673958,479511,398441,114683,897469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]