SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380558 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380558 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421544,829654,889122,120869,112739,384207,434013,228919,580366,12402,90010,503100,309137,411994,492856,975489,55614,148415,668579,1046224,265011,249308,360991,718961,443929,954564,453438,273666,287294,789999,824452,14975,546514,110578,335243,128397,996406,300059,199205,415478,461009,613004,740040,707332,494570,591567,490405,631211,707067,261323,301493,761401,41862,117880,609837,650348,766042,705075,382943,897825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380558 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380558 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002194s ]