SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046831 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046831 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120996,480009,425443,188766,427699,946374,188993,566742,259428,971984,441023,507011,954158,696232,175348,802369,616794,266461,617545,439436,48671,432412,175390,1030128,183361,14911,123738,532110,895467,666815,726019,342967,221977,1047274,862084,757935,640188,474585,872659,800435,843064,648351,439053,804734,436171,652081,518871,527325,600669,483512,666772,808381,334278,9506,424647,205723,1025794,781164,810010,453678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]