SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532648 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532648 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946416,505404,138046,949872,840892,245315,106097,341709,572278,386815,520323,124346,846129,123720,674107,849517,330935,130816,132780,852676,62164,232297,271991,811589,647739,888848,261083,39291,884575,386330,743272,937180,824044,920562,647884,65159,168908,10379,744703,463340,856179,1027758,357311,585006,142610,186267,427659,996673,892960,736123,171330,359404,739125,987711,132542,359054,961189,337130,869746,942604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]