SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039311 LIMIT 1 [ RunTime:0.000635s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039311 [ RunTime:0.002186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357172,948016,138722,1010950,950984,618224,859584,100729,736737,143521,397108,667373,6390,621189,309540,582747,767420,92812,452055,370325,578297,61897,309523,310756,78953,670510,531689,773942,184911,175402,493569,490040,609954,232170,1007942,919448,249954,681289,355937,1001840,196921,767650,461547,112978,905510,950606,767772,90894,702222,553942,377759,269231,380123,546855,859511,640003,272281,937289,921394,354038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]