SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861806 LIMIT 1 [ RunTime:0.000495s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861806 [ RunTime:0.002006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200340,953143,793136,851156,857006,180358,718118,880600,354336,180795,143643,881092,902827,255582,260740,995957,517214,193938,947303,886437,283116,996830,170212,581412,244211,237301,660689,1016841,126281,731410,519261,384814,506866,178009,539457,774408,220624,749014,825111,971129,250202,430144,177456,399634,722228,952019,219369,366382,730705,543140,758096,478439,142718,357573,912084,815071,617032,656353,327134,857182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.022043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005288s ]