SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044331 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044331 [ RunTime:0.002625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357600,513760,222693,246455,910642,669551,987361,673248,419154,374586,857455,311967,681888,525102,659259,587753,594676,277941,279580,149418,492494,651478,937050,813934,948052,604005,613290,723502,164550,1004833,1024531,504177,102407,900618,557333,985019,836245,419780,15020,319415,620020,603032,678221,531496,229663,654398,40056,304096,428165,169340,699088,110170,896412,945706,514194,58444,467041,659689,174341,644530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]