SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041822 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041822 [ RunTime:0.001971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199040,814277,465339,619630,134815,355126,263372,818816,450987,674047,547477,655111,806753,603677,92950,20172,102770,483057,843134,419462,556769,81407,723502,1006223,968155,835143,479863,841268,843492,984261,622653,442842,796822,423998,128965,1020206,952294,780712,843706,498466,404287,677511,375369,386276,545905,403666,193472,219506,570649,263675,802457,838357,352090,41844,865389,358060,129830,348886,67479,831768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001709s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]