SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505580 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505580 [ RunTime:0.001446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789994,997998,602972,630286,193321,214630,236675,27295,163994,38556,136067,526203,853364,889130,1045538,297649,270273,432973,524153,599650,598313,577665,1013167,92549,685291,40889,33499,464166,790585,796221,956965,205708,322440,80226,345943,332534,983431,862096,216423,209082,57494,952650,833377,83861,22816,458932,824098,168319,254687,756328,710918,181201,611552,940555,954299,536051,106427,342865,17717,866791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]