SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 362247 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 362247 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499480,577939,367425,904230,200624,174681,427815,466156,615989,749163,221185,4003,283017,971616,715413,483162,354813,906284,110961,1007678,527881,611858,836863,1025455,297765,437417,53074,920881,454370,125378,177158,123939,493392,296735,887455,882435,186093,294270,367598,291868,834085,815258,64574,469441,389175,673090,607341,790351,927183,310792,702028,416338,778201,917142,153510,253292,384011,1021310,452867,1035756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 362247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 362247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]