SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501883 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501883 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791745,225438,709199,365733,171031,135422,254058,229371,117494,75204,75589,871583,337177,1020828,345332,519797,1016940,982208,775673,360938,807410,115063,846977,92406,780601,815529,563695,609714,662116,922672,756266,487037,624645,606970,835737,581413,585563,341617,744314,136541,358518,1000891,530141,433608,247137,421686,686180,744169,684065,128337,359433,1033452,505672,986268,531151,398552,18200,514711,350357,128500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]