SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514811 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514811 [ RunTime:0.002033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330171,470460,743355,948509,381256,889585,324763,445325,849608,109965,402970,383559,91261,378459,966231,203569,546974,409895,52983,965496,750321,711815,218727,72302,919492,794209,541825,858807,259914,905015,890812,130194,53043,848358,298406,94512,22040,167440,378902,54399,1025095,188778,943103,634995,517894,265766,27003,53784,11172,995397,221954,93850,218647,598461,761850,179081,227680,189175,523135,463792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]