SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415016 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415016 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913356,969,546070,718108,783809,307082,330788,44645,554008,287089,1002112,196556,436847,359834,890129,913312,447800,377205,937134,1029909,448193,782714,369725,858857,1033275,734693,951252,468528,57334,496054,594765,3390,1015663,819692,799812,914205,300064,147282,702935,955644,941596,379046,741296,880536,738332,125469,387195,143511,629946,920143,996880,285031,541474,820919,16126,253477,996300,794024,2808,431175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]