SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028008 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028008 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553325,873070,581196,103573,236073,210505,190534,960728,1003466,233859,550253,688268,400263,822776,289776,431334,104479,838938,902225,180194,270203,328830,298498,492100,193465,39316,507898,961537,217285,992033,304892,616928,107154,755273,282321,301113,1009029,672687,316739,426771,291041,838801,943455,1034127,836947,223414,523997,108269,486573,719166,522729,33599,710289,348117,398184,509722,904807,62099,576435,235362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]