SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 208180 LIMIT 1 [ RunTime:0.000554s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 208180 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29418,699290,80739,458961,543231,732891,281299,647938,310683,369948,733297,828838,404690,577830,440621,882803,92162,652612,789641,338012,706858,98719,562801,910958,254136,108185,630958,385513,540490,833059,593322,256321,1018438,319043,770174,622500,921573,523299,845161,58400,323376,109177,751878,958766,55821,840471,215739,633141,764672,887681,51391,268265,199853,385124,329385,419833,455907,256679,105817,744371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 208180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000811s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 208180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]