SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003452s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410911 LIMIT 1 [ RunTime:0.001707s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410911 [ RunTime:0.007736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545536,66050,961041,83443,486379,646926,829848,217379,948410,545553,446811,574766,54158,595892,778259,541121,609132,15928,259910,650157,278589,847287,493201,3996,148259,316900,315654,754724,554376,963165,160800,750750,148574,76856,239604,112687,302182,98776,282421,389087,546536,97456,636324,132816,136155,377635,66708,823942,889702,326455,96532,1019390,211840,784702,646645,4039,92620,981703,193557,183388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]