SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002449s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502743 LIMIT 1 [ RunTime:0.001233s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502743 [ RunTime:0.004569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706867,149877,974107,624335,864087,711532,410222,56737,485441,469726,269000,838458,76104,273444,361192,184016,261901,930237,69318,400070,1036285,790784,684865,306061,28637,358628,264184,669215,20870,934601,375617,730782,552724,830909,617039,407731,593079,43089,877732,157511,794713,964258,897775,195391,518131,802719,444055,1021186,499425,112139,931477,684960,710541,542195,797607,771815,286470,412133,545329,345722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001787s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000860s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000959s ]