SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111050 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111050 [ RunTime:0.004650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443533,433898,193722,120941,1017380,928331,274126,738751,890650,855690,617320,1136,557206,555064,211364,245221,790930,236699,8663,395446,23374,101329,770252,1004615,515389,20149,777306,614339,774884,750777,695477,215146,576207,722974,674746,198256,918127,444107,865326,89631,871941,542105,484668,1019634,641381,553738,258129,104334,874845,130004,690208,92400,403334,290965,132336,906902,944558,733503,482395,747900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]