SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29140 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29140 [ RunTime:0.002044s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20328,623527,475630,558150,407163,888478,415172,376709,45971,978840,596470,1002241,746342,306476,1015559,196661,557084,316237,896392,245901,186687,891416,1028590,1042083,11640,188572,706462,446899,607787,401792,319071,739543,477393,799777,424989,143034,714362,724974,659675,27278,473126,205592,917383,413951,851300,18228,1014006,410454,829604,150789,823777,996389,167224,792031,111005,597005,458210,663545,889688,260466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]