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` = 506991 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506991 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413333,1047147,533430,916909,502366,488743,483319,768024,8143,861448,734798,688204,486455,350433,576109,945382,220633,441003,8628,411205,369608,3506,500031,388197,4634,187391,868911,315527,923594,336804,376047,308403,611135,844342,693035,781433,1042090,843739,376726,507418,515449,151595,629955,943862,599228,711936,576165,615058,389012,275820,123017,103914,903742,205540,672627,124893,288321,901037,432291,549283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]