SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292536 LIMIT 1 [ RunTime:0.001152s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292536 [ RunTime:0.002768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596577,400877,390844,316086,963863,914532,43689,920444,575634,744232,404848,324503,535738,583026,671097,368981,787223,333291,96471,380285,247350,192300,354058,266098,877773,226175,30803,144871,24501,509936,502614,145492,920399,8863,1008485,755301,677895,453387,665296,285196,856686,564759,896130,1028845,248315,300637,117807,172292,292109,738090,703972,529287,445503,768278,518356,777106,356645,855135,917352,1027982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292536 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292536 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000364s ]