SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039501 LIMIT 1 [ RunTime:0.003278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039501 [ RunTime:0.002762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975639,621764,848987,394318,437731,253068,75036,193601,626821,64238,583206,1038238,623972,980989,876641,133421,532169,979431,820944,534856,438699,973743,152213,441919,672641,599893,129728,859314,726028,27584,874784,36525,578990,1033759,672747,692956,928650,688649,631570,322614,649683,335995,989655,164378,500062,519865,302126,595625,229390,904798,463814,572974,720470,395705,631612,660423,414504,311973,564248,1019062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002828s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001811s ]