SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41753 LIMIT 1 [ RunTime:0.001896s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41753 [ RunTime:0.004164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (637418,611442,77054,217930,340528,703679,143502,455314,951045,1000501,919641,765794,665320,590403,769492,384123,492548,920217,934753,575073,505556,756755,83499,881265,948238,306922,586398,25571,695247,304030,924795,48025,1039850,937559,167809,432511,214440,232218,453872,86156,752608,990069,837737,479551,539995,251704,1036902,941803,850334,1021563,154685,597337,424575,1019582,828078,208175,1006807,245740,891294,257457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]