SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003538s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802954 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802954 [ RunTime:0.004554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843503,438799,259705,1020069,7659,929552,352980,86508,644528,948393,141924,386431,18202,730438,639655,21360,841776,414645,109107,1015942,839427,189450,181326,714315,1028977,637823,147364,854345,681534,583985,273016,588218,408354,322683,820111,618357,572841,845189,995875,599302,156498,23573,469379,1013628,378930,418013,94455,166199,992000,139279,812340,401576,346339,95993,739079,599754,685330,378008,190162,117762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002751s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]