SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109820 LIMIT 1 [ RunTime:0.002207s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109820 [ RunTime:0.002338s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487876,235703,992759,75792,457471,1004461,606628,815530,544866,81272,646716,725694,657146,430756,977158,1015660,564531,903565,289545,164031,669674,84058,753502,319246,353048,146383,952739,983614,349168,659354,453060,296916,820176,652158,754717,51882,362004,798879,527501,153244,375055,790176,974357,587408,1022497,753450,915760,805321,271904,445128,427399,282357,385504,57209,742560,766886,165478,907968,1037702,705522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001824s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]