SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404800 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404800 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452391,959921,132919,612988,253200,110338,925019,416791,755897,328475,287786,448381,771162,222273,784569,1041494,973165,27317,40087,35683,757396,857020,708502,794516,998103,931001,188855,475331,519795,617008,824582,217132,569986,868489,141624,414471,229485,489772,858564,91756,88616,721818,688260,61399,573074,425220,203013,270535,588595,168060,460482,1048071,833121,458990,825816,514588,49725,29237,715181,406246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]