SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550301 LIMIT 1 [ RunTime:0.000638s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550301 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114272,978443,855119,993105,794210,599915,864533,8733,436284,775079,708916,586400,307921,191524,73253,463919,515735,626549,319964,851766,368420,918782,728878,453751,813990,758655,225000,617441,21359,646623,321822,686088,126449,387028,270165,1046342,913661,795389,654062,332355,505001,715002,896056,888484,831801,728570,215894,133603,606942,358367,433971,497361,241993,114001,263471,733363,580553,283791,697013,671589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]