SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.016802s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017841 LIMIT 1 [ RunTime:0.001064s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017841 [ RunTime:0.019684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472378,238791,795304,679611,157124,1016764,926965,466217,148461,908164,419869,357799,720038,110247,129310,653847,816528,392348,494439,1009835,731693,262662,527562,258495,153205,629392,138938,533079,24482,42475,148538,955759,719132,626572,869055,173028,469323,1019813,725056,40631,810567,169315,647699,156458,78063,435647,898558,107868,143022,928493,603565,539616,834461,571654,575675,167973,80809,659725,398504,36997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008714s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.011179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007547s ]