SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438540 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438540 [ RunTime:0.002666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546903,637907,724481,801800,1044031,11291,1041056,893107,546911,502543,108484,976782,993242,726501,734839,518040,783853,720167,67403,154535,169215,1012818,155855,902201,482828,15533,991716,645932,294093,271821,687351,101700,209044,273892,224980,647081,426284,640723,924540,183647,985780,8338,133789,216329,610298,953226,222482,247950,761211,637544,587025,873704,550809,1035330,170212,890061,687510,46920,264241,288420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000822s ]