SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041146 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041146 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80180,107413,702258,733389,429667,164645,414288,855349,612813,712054,800460,135453,311977,735040,1020925,840522,901029,739279,796885,568860,352750,281873,176232,596884,859863,386919,457154,787999,405090,599669,585847,294442,404675,1020743,27675,11376,494795,876089,741802,240750,959965,441633,629403,303105,405902,88017,123267,453135,533996,36889,13335,917233,711142,527404,196612,824361,92458,368512,380185,314258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]