SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403116 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403116 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489881,259162,408097,330510,183124,228253,271725,8238,422392,866665,676639,90889,829340,880287,586294,774274,605181,94850,788660,256344,967222,1042169,260851,425726,268008,545026,407097,990429,803642,257603,73010,49190,351830,965801,120670,8400,784956,279381,472785,267265,393745,553058,628061,346698,65627,957521,458900,262673,107001,228903,456538,11711,922547,74558,19487,769820,648433,801650,403109,902765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]