SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425750 LIMIT 1 [ RunTime:0.001775s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425750 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617724,567471,989078,7175,944948,665542,184836,834771,722006,295430,744026,786077,702357,254890,771270,913714,200784,985705,61681,355373,459463,543125,794871,730479,785940,489811,500520,539395,1018283,15650,157332,380852,516157,318257,328571,758610,266995,186528,420659,665757,441371,148631,443372,845789,972449,340335,318462,782784,870736,849809,872899,343594,866885,834151,1012103,60025,269535,1006537,380588,216779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]