SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3143 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3143 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920935,91974,676721,856025,327524,781446,83734,85734,394229,24580,488530,363826,1023765,305973,626521,349919,926008,550543,974205,549203,937919,502174,711481,282061,608510,308235,247645,324414,567107,640981,997093,386041,5921,425006,376624,776378,313033,340645,245456,397417,396738,879222,759652,945479,424029,975492,751478,365217,666324,458170,789919,509697,300577,355989,764248,689090,885426,67330,525394,85657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002123s ]