SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423754 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423754 [ RunTime:0.004554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534139,1006081,819823,199887,653030,157161,986574,1038828,401356,837882,4775,905964,77899,29054,339983,958298,214100,183278,593241,928543,818891,762642,894685,567837,49548,654905,937207,31172,427499,661405,573979,484140,395463,405879,186916,1008076,63744,973553,430574,608312,760883,188118,798670,330321,738782,134776,154557,803487,919886,303889,514351,814236,544512,389306,616864,132249,218648,229537,312850,499609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]