SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438260 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438260 [ RunTime:0.002496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144399,300016,186689,811543,149816,59242,992435,4206,463551,371069,213419,581478,40542,194967,919263,330396,645553,180924,949072,688480,1018807,77,186985,658213,609026,686943,331304,588500,297451,675522,269366,463323,895567,806193,1002068,277934,46868,723692,342256,245423,619842,932781,175518,741428,477487,70801,964334,954492,541444,24433,74131,477504,47120,795108,413171,341236,971677,353011,157742,428932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000811s ]