SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023805 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023805 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (74590,187414,129945,254209,817585,657743,1025906,645478,646296,746351,501248,886715,98017,775037,815177,828352,680400,93359,782083,520040,353482,640136,31208,697556,488682,824501,374441,496189,872149,151678,116861,734504,918573,692982,853659,832428,442995,316113,720821,3726,157314,997995,418314,629407,393065,16183,203203,663966,596409,379007,501768,642936,421533,501816,326621,169212,367892,24199,689744,336072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]