SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428047 LIMIT 1 [ RunTime:0.000498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428047 [ RunTime:0.002117s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836833,226183,880129,1010426,845042,91148,802377,177434,568445,742805,428209,875774,515529,845262,89780,558049,343245,339611,162548,201924,90681,71997,2459,942231,180318,594493,466228,890474,439533,961679,713385,363568,809013,199569,739978,5053,294172,850250,621152,833039,875230,887373,526404,542447,71945,177999,1008462,629221,79661,658946,622374,857990,445208,183480,995225,676827,483140,315557,353179,43657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]