SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016346 LIMIT 1 [ RunTime:0.000276s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016346 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515872,455408,848241,596851,476947,265977,351946,816157,199633,112990,135310,680885,973241,785020,825662,78124,551011,822109,980574,904668,728626,600731,408598,730190,962469,791875,1036690,11122,91918,26238,379858,461589,364100,145824,504847,480204,649089,328098,69801,389221,776390,632909,545750,530010,592470,906587,243943,338957,789907,337137,642017,277915,448548,541262,123561,923841,651569,673192,464363,893891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]