SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030222 LIMIT 1 [ RunTime:0.001099s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030222 [ RunTime:0.004711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533116,710862,514212,833247,663970,715102,330165,195995,537596,10696,1008084,979942,375514,566522,657594,860312,902784,96294,368556,408316,487098,900165,463448,67149,271517,632913,59994,12143,174682,1024015,922173,168723,916399,121008,1010044,992334,109247,913821,655968,1042843,229558,218556,358706,72122,749205,337121,628655,343804,76189,550957,562533,13300,722258,108517,612399,154179,647672,431283,53938,968072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000386s ]