SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109818 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109818 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518649,863574,223374,917113,876925,909487,158429,659891,277357,1007850,651877,18528,10094,624918,621179,895865,776295,577310,538766,276878,117724,28203,14531,422930,707243,717674,1030255,780257,660499,969735,123841,76134,1006060,565892,133517,812071,972205,737481,256231,697358,385700,246207,984846,559780,416474,103005,36087,531006,335359,713473,387506,256233,506824,1027833,103801,1032015,506109,956575,1040989,522257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]