SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410896 LIMIT 1 [ RunTime:0.000733s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410896 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40090,890323,803130,796132,35779,660969,40015,793366,987069,817150,579409,780665,558423,143478,362796,150889,211719,332240,706043,264048,550306,800280,642543,299990,900423,234358,734816,678910,261853,1033721,65963,136401,974160,57883,226603,56233,153050,693603,712730,581514,504458,703534,114204,182076,221810,650189,43404,791212,690846,838490,358386,131819,888592,184446,636562,479020,126034,105178,652756,866316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]