SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 810760 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 810760 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809391,25361,59056,143887,603287,190048,795111,631121,709969,316900,106729,243326,545543,306199,149604,336483,829593,431968,260789,380105,677345,258323,985353,523424,165068,471931,113620,155394,178197,189274,573990,191521,8946,898907,924709,972366,654890,63070,922880,948045,212115,328346,616985,888589,954449,902823,371046,954210,985206,814316,656918,847406,956788,501422,737608,386951,12957,176298,1035110,865820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 810760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 810760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]