SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038621 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038621 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178246,64703,39886,874024,346738,391453,17205,730444,819069,716751,271561,1001848,163720,223643,468911,190743,945722,201236,664644,572200,209078,386412,339993,624216,684421,809745,901794,876351,105510,931736,325061,672719,543280,191387,404058,290721,350825,12001,1010130,452335,174633,837720,147770,46723,754669,883831,848255,905140,1003040,1934,890925,46335,222230,335919,228029,369090,107574,664292,763288,593753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]