SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001870s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039216 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039216 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042881,599671,727329,736886,904257,424260,931983,708313,833028,305457,36377,558814,106934,587598,446773,574870,243259,319352,153641,523705,135845,615789,582096,458565,617285,38830,1041492,187015,289340,740400,43384,674149,547954,535747,899845,945084,1026048,815899,685699,151250,860720,997427,282947,385464,287796,401084,92023,255061,296286,640879,523292,751304,38542,132207,830747,40377,336242,1011672,746096,1014258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]